[
https://issues.apache.org/jira/browse/CALCITE-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
shradha updated CALCITE-4455:
-----------------------------
Description:
Enhance Calcite SQLParser to support INSERT OVERWRITE:
Current Behavior: Parsing queries having INSERT OVERWRITE throws exception
{color:#008000}INSERT OVERWRITE TABLE sbg_schema.tableA
select distinct SURV_MARK_CUST_IDEN
,latest_surv_oci
,tran_mark_cust_iden
,surv_tran_mci
,orgz_mark_cust_iden from tableB{color}
{color:#008000}StatementMetadataFragment(com.intuit.superglue.pipeline.parsers.CalciteStatementParser,UNKNOWN,List(),List(),List(org.apache.calcite.sql.parser.SqlParseException:
Encountered "OVERWRITE" at line 2, column 8.{color}
{color:#008000}All these queries are correctly being parsed via SPARK SQL . But
calcite's parser grammer file doesn't suport these tokens{color}
Since this is SPARK SQL specific , these changes will be implemented in BABEL
Parser
> Calcite SQLParser: Provide support for INSERT OVERWRITE
> -------------------------------------------------------
>
> Key: CALCITE-4455
> URL: https://issues.apache.org/jira/browse/CALCITE-4455
> Project: Calcite
> Issue Type: Sub-task
> Components: spark
> Reporter: shradha
> Priority: Major
>
> Enhance Calcite SQLParser to support INSERT OVERWRITE:
> Current Behavior: Parsing queries having INSERT OVERWRITE throws exception
>
> {color:#008000}INSERT OVERWRITE TABLE sbg_schema.tableA
> select distinct SURV_MARK_CUST_IDEN
> ,latest_surv_oci
> ,tran_mark_cust_iden
> ,surv_tran_mci
> ,orgz_mark_cust_iden from tableB{color}
> {color:#008000}StatementMetadataFragment(com.intuit.superglue.pipeline.parsers.CalciteStatementParser,UNKNOWN,List(),List(),List(org.apache.calcite.sql.parser.SqlParseException:
> Encountered "OVERWRITE" at line 2, column 8.{color}
>
> {color:#008000}All these queries are correctly being parsed via SPARK SQL .
> But calcite's parser grammer file doesn't suport these tokens{color}
> Since this is SPARK SQL specific , these changes will be implemented in BABEL
> Parser
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
