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

[Akash R Nilugal (Jira)]

    [ https://issues.apache.org/jira/browse/CARBONDATA-1201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16056904#comment-16056904 ]

chenerlu commented on CARBONDATA-1201:
--------------------------------------

I remember this syntax may not support on spark1.6.2, while spark2.1 support.
So first we can confirm if that spark issue.

> 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)