Skip to Content
avatar image
Former Member

SDA Create Virtual table on HIVE table with PARQUET format gives JDB[257] Error

Hi,

We're using HADOOP(ODBC) to create SDA connection with HIVE. Connection is working fine and able to see all tables defined on HIVE schema. I'm getting below error when tried to create a virtual table on HIVE table defined with PARQUET format. It is working fine for table created with TEXT format.

SAP DBtech JDBC: [257]: sql syntax error: incorrect syntax near """; Line 1 col 942 (at pos 942)

Is PARQUET table format supported in HANA SDA? Is there a way I can see the SQL generated for CREATE VIRTUAL TABLE? How can it be fixed?

Thanks,

Milind




Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers