[jira] [Created] (CARBONDATA-2864) Carbon Update not supported in Spark2.x

[Akash R Nilugal (Jira)]

anand created CARBONDATA-2864:
---------------------------------

             Summary: Carbon Update not supported in Spark2.x
                 Key: CARBONDATA-2864
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2864
             Project: CarbonData
          Issue Type: Bug
            Reporter: anand


Carbon update statement was not working in Spark2.x.

 

Error Log

carbon.sql("UPDATE test_table t SET(name)='T' where t.id = 10");

org.apache.spark.sql.AnalysisException: == Parse1 ==

 

mismatched input 'UPDATE' expecting \{'(', 'SELECT', 'FROM', 'ADD', 'DESC', 'WITH', 'VALUES', 'CREATE', 'TABLE', 'INSERT', 'DELETE', 'DESCRIBE', 'EXPLAIN', 'SHOW', 'USE', 'DROP', 'ALTER', 'MAP', 'SET', 'RESET', 'START', 'COMMIT', 'ROLLBACK', 'REDUCE', 'REFRESH', 'CLEAR', 'CACHE', 'UNCACHE', 'DFS', 'TRUNCATE', 'ANALYZE', 'LIST', 'REVOKE', 'GRANT', 'LOCK', 'UNLOCK', 'MSCK', 'EXPORT', 'IMPORT', 'LOAD'}(line 1, pos 0)

 

== SQL ==

UPDATE test_table t SET(name)='T' where t.id = 10

^^^

 

== Parse2 ==

Parsing error, missing bracket;

  at org.apache.spark.sql.util.CarbonException$.analysisException(CarbonException.scala:23)

  at org.apache.spark.sql.parser.CarbonSparkSqlParser.parsePlan(CarbonSparkSqlParser.scala:71)

  at org.apache.spark.sql.CarbonSession.withProfiler(CarbonSession.scala:144)

  at org.apache.spark.sql.CarbonSession.sql(CarbonSession.scala:95)

  ... 50 elided



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)