java.sql.SQLException: (SQLState=42X01 Severity=20000) (Server=servername[1527] Thread=ThriftProcessor-913) Syntax error: Encountered "" at line 1, column 106. Was expecting one of: . at io.snappydata.thrift.SnappyDataService$prepareStatement_result$prepareStatement_resultStandardScheme.read(SnappyDataService.java:10738)

[annpricksedmund]

We are facing an issue for below case

CREATE TABLE TESTSC (groupid INT,companyid INT,id INT,previd INT,flag INT,updated INT) USING COLUMN;
INSERT INTO TESTSC VALUES(1,1,1,0,1,null);
INSERT INTO TESTSC VALUES(1,1,2,1,0,1);
INSERT INTO TESTSC VALUES(1,1,3,2,1,null);
SELECT * FROM TESTSC;

CREATE TABLE TESTSC1(groupid INT,companyid INT,description VARCHAR(100)) USING COLUMN;
INSERT INTO TESTSC1 VALUES(1,1,'Testing');
INSERT INTO TESTSC1 VALUES(2,1,'Testing Two');

UPDATE TESTSC SET 
 tt.updated = 1
from TESTSC tt INNER JOIN TESTSC1 tt1
ON tt.groupid = tt1.groupid AND tt.companyid = tt1.companyid
WHERE (
(previd <> id
and previd <> 0)
or (flag = 1)
);

When i run the update statement through embedded mode (Create Jar file and submitted through snappy-job.sh submit), it is working fine. However, When I run the same update through smart connector mode (Through IDE connecting snappy cluster using snappydata.connection), it is giving below error.

"java.sql.SQLException: (SQLState=42X01 Severity=20000) (Server=servername[1527] Thread=ThriftProcessor-913) Syntax error: Encountered "" at line 1, column 106.
Was expecting one of:
.
at io.snappydata.thrift.SnappyDataService$prepareStatement_result$prepareStatement_resultStandardScheme.read(SnappyDataService.java:10738)"

I am using "io.snappydata" % "snappydata-cluster_2.11" % "1.0.2.1" package in my build.sbt as a dependency