[jira] [Created] (CARBONDATA-1201) don't support insert syntax "insert into table select constants" on spark 1.6.2

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-1201) don't support insert syntax "insert into table select constants" on spark 1.6.2

Akash R Nilugal (Jira)
Jarck created CARBONDATA-1201:
---------------------------------

             Summary: don't support  insert syntax  "insert into table select  constants" on spark 1.6.2
                 Key: CARBONDATA-1201
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1201
             Project: CarbonData
          Issue Type: Bug
            Reporter: Jarck


I use branch-1.1 do insert test on spark 1.6.2 in my local machine
I try to  run the sql like "insert into table select  constants", but it failed
it works on spark 2.1.
example sql:
      spark.sql(s"""
             insert into $tableName select $id,'$date','$country','$testName'
             ,'$phoneType','$serialname',$salary
             """).show()

error log as below

FailedPredicateException(regularBody,{$s.tree.getChild(1) !=null}?)
        at org.apache.hadoop.hive.ql.parse.HiveParser.regularBody(HiveParser.java:41238)
        at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpressionBody(HiveParser.java:40413)
        at org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:40283)



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)