org.apache.spark.sql.catalyst.parser.ParseException occurs when insert statement contains column list

Using the Connect for ODBC Spark SQL driver, an error occurs when the insert statement contains a column list. org.apache.spark.sql.catalyst.parser.ParseException: mismatched input '<column name>' expecting {'(', 'SELECT', 'FROM', 'VALUES', 'TABLE', 'INSERT', 'MAP', 'REDUCE'}

Jan 29, 2018
Knowledge

Title

URL Name

org-apache-spark-sql-catalyst-parser-parseexception-occurs-when-insert-statement-contains-column-list

Article Number

000116396

Environment

Product: Connect for ODBC Spark SQL driver Version: 7.1 O/S: Windows Database: Spark SQL Application: N/A

Question/Problem Description

Using the Connect for ODBC Spark SQL driver, an error occurs when the insert statement contains a column list. org.apache.spark.sql.catalyst.parser.ParseException:
mismatched input '<column name>' expecting {'(', 'SELECT', 'FROM', 'VALUES', 'TABLE', 'INSERT', 'MAP', 'REDUCE'}

Steps to Reproduce

Clarifying Information

Error Message

[DataDirect][ODBC Apache Spark SQL Wire Protocol driver][Spark SQL]org.apache.spark.sql.catalyst.parser.ParseException: mismatched input '<column name>' expecting {'(', 'SELECT', 'FROM', 'VALUES', 'TABLE', 'INSERT', 'MAP', 'REDUCE'}(line 1, pos 24)

Defect Number

Enhancement Number

Cause

Spark SQL does not support column lists in the insert statement.

Resolution

It was determined that the Progress Product is functioning as designed.

An enhancement request has been submitted as an Idea on the Progress Community. To promote the Idea, click on this link: https://datadirect.ideas.aha.io/ideas/DDIDEAS-I-519. Customer feedback is valuable and Idea submissions are monitored by our Product Management team. Enhancement requests are reviewed during the planning phase of each new product release and a list of the enhancements chosen for implementation can be found in the Release Notes documents that accompany each release. Once an Idea is submitted the Progress Software Community will have the opportunity to comment on and vote for the Idea. It's priority will be evaluated as customer demand weighs in through Article Feedback and through vote count in the Ideas Portal

For detailed information on how to submit an Idea, please refer to Knowledge Base article How to submit an enhancement request for a Progress product?.

This enhancement has not been implemented in the product. As an alternative use the workaround below.

Exclude the column list from the insert statement.

Instead of:
INSERT into tablename (col1, col2, col3) VALUES ('1', '2','3')
Use:
INSERT into tablename VALUES ('1', '2','3')

Workaround

Notes

Keyword Phrase

Last Modified Date

4/13/2023 5:10 PM

org.apache.spark.sql.catalyst.parser.ParseException occurs when insert statement contains column list

Files(0)

Was this article helpful?

Was this article helpful?

org.apache.spark.sql.catalyst.parser.ParseException occurs when insert statement contains column list

Information

Related Articles