[ https://issues.apache.org/jira/browse/CARBONDATA-1201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16073289#comment-16073289 ]
Prabhat Kashyap commented on CARBONDATA-1201: --------------------------------------------- I've confirmed it that Spark 1.6 not support this syntax. > 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)