[jira] [Commented] (CARBONDATA-640) Insert Query with Hardcoded values is not working
[ https://issues.apache.org/jira/browse/CARBONDATA-640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15827495#comment-15827495 ] Vyom Rastogi commented on CARBONDATA-640: - Above Scenario is Working with Hive for insert queries insert into employees select t.* from ( select 'harry','h2399','v788232',99823230205 ) t; > Insert Query with Hardcoded values is not working > - > > Key: CARBONDATA-640 > URL: https://issues.apache.org/jira/browse/CARBONDATA-640 > Project: CarbonData > Issue Type: Bug > Components: sql >Affects Versions: 1.0.0-incubating >Reporter: Vyom Rastogi >Priority: Minor > Labels: Spark-1.6 > Attachments: insert_data.png > > > 1)Creating table employees,Managers > create table employees(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata'; > 2)create table managers(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata'; > Insert into Select Queries > insert into managers select 'harry','h2399','v788232',99823230205; > Error Description: > Error: org.apache.spark.sql.AnalysisException: Failed to recognize predicate > ''. Failed rule: 'regularBody' in statement; line 1 pos 65 > (state=,code=0) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CARBONDATA-640) Insert Query with Hardcoded values is not working
[ https://issues.apache.org/jira/browse/CARBONDATA-640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15824376#comment-15824376 ] Ravindra Pesala commented on CARBONDATA-640: [~vyom_huawei] Please verify this scenario once with Hive and check the behavior. > Insert Query with Hardcoded values is not working > - > > Key: CARBONDATA-640 > URL: https://issues.apache.org/jira/browse/CARBONDATA-640 > Project: CarbonData > Issue Type: Bug > Components: sql >Affects Versions: 1.0.0-incubating >Reporter: Vyom Rastogi >Priority: Minor > Labels: Spark-1.6 > Attachments: insert_data.png > > > 1)Creating table employees,Managers > create table employees(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata'; > 2)create table managers(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata'; > Insert into Select Queries > insert into managers select 'harry','h2399','v788232',99823230205; > Error Description: > Error: org.apache.spark.sql.AnalysisException: Failed to recognize predicate > ''. Failed rule: 'regularBody' in statement; line 1 pos 65 > (state=,code=0) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CARBONDATA-640) Insert Query with Hardcoded values is not working
[ https://issues.apache.org/jira/browse/CARBONDATA-640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15823527#comment-15823527 ] Anurag Srivastava commented on CARBONDATA-640: -- Hi Vyom, Can you please use this query ? *Query :* insert into employees select t.* from ( select 'harry','h2399','v788232',99823230205 ) t; This query will insert data into your table. > Insert Query with Hardcoded values is not working > - > > Key: CARBONDATA-640 > URL: https://issues.apache.org/jira/browse/CARBONDATA-640 > Project: CarbonData > Issue Type: Bug > Components: sql >Reporter: Vyom Rastogi >Priority: Minor > > 1)Creating table employees,Managers > create table employees(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata'; > 2)create table managers(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata'; > Insert into Select Queries > insert into managers select 'harry','h2399','v788232',99823230205; > Error Description: > Error: org.apache.spark.sql.AnalysisException: Failed to recognize predicate > ''. Failed rule: 'regularBody' in statement; line 1 pos 65 > (state=,code=0) -- This message was sent by Atlassian JIRA (v6.3.4#6332)