Skip to Content
0

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

May 02 at 05:16 PM

16

avatar image
Former Member

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




10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers