You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@carbondata.apache.org by "Jarck (JIRA)" <ji...@apache.org> on 2017/06/20 10:30:00 UTC

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

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)