Skip to Content
0

VORA 1.4 Dev Create schema error during init with error code 0, status ERROR_STATUS

Oct 09, 2017 at 10:33 PM

46

avatar image
Former Member

After installing VORA 1.4 Dev VM, I seem to be able to install ok, but get when I try to create the sample table as per SQL script below I get the Create Schema error below when using /web/#/sql-editor

SQL
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (age INT, name STRING) USING com.sap.spark.engines.relational OPTIONS (files "/user/vora/t1.csv");
SHOW TABLES;
SELECT * FROM t1;


LOG
DROP TABLE IF EXISTS t1
executed in 10.178857ms
Failed to execute: CREATE TABLE t1 (age INT, name STRING) USING com.sap.spark.engines.relational OPTIONS (files "/user/vora/t1.csv")
com.sap.vora.jdbc.HanaVoraJDBCException: Create schema error during init with error code 0, status ERROR_STATUS
SHOW TABLES
executed in 12.356837ms
Failed to execute: SELECT * FROM t1
org.apache.spark.sql.AnalysisException: Table not found: t1; with error code 0, status ERROR_STATUS

Is there a step that I have missed or some other reason? I look to have created the t1.csv file and placed in in the HDFS ok as I can see it there.
(problem is at Step 12 - https://www.sap.com/developer/how-tos/2017/02/vora-ova-install.html)

thanks for your help.

Matt

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

1 Answer

Witalij Rudnicki
Oct 17, 2017 at 10:20 AM
0

Hi. Have you created a t1.csv file in Hadoop file system as described earlier in that step of the tutorial?

Share
10 |10000 characters needed characters left characters exceeded