search

SAP-archive / HANAVora-Extensions

Spark extensions for business contexts
Apache License 2.0
36 stars 18 forks source link

Issue with append data command #3

Closed sbcd90 closed 8 years ago

sbcd90 commented 8 years ago

Hello,

I tried executing the following command

%vora APPEND TABLE EMPLOYEE OPTIONS (paths "hdfs://localhost:9000/tmp/SHA_Employee_append.csv", eagerLoad "true")

& I got the following error

Error: com.sap.spark.hana.HANARelation cannot be cast to org.apache.spark.sql.sources.AppendRelation

Kindly note, the basic commands like read/write to hana works fine still for me. Can somebody help?

Thanks & regards, Subhobrata

stephankessler commented 8 years ago

Hi Subhobrata,

the append command has to be supported by the datasource, this is not the case for the HANA datasource (while it is for the Vora one) - so this won't work.

If you want do pass data back to hana, you have to write or insert as usual.

Does this answer your question?

Best, Stephan

sbcd90 commented 8 years ago

Thanks. Yes. That answers my question.