Skip to Content
0
Jun 23, 2017 at 08:57 AM

Unable to CREATE table in SAP VORA

154 Views Last edit Jul 18, 2017 at 11:19 AM 3 rev

We are trying to create table in Vora, n we are using Spark 1.6, Spark Controller 2.0, HDP 2.4.2 and Vora 1.3.

Issues Facing:

At a time of creating a table from vora spark shell using query,

import org.apache.spark.sql.SapSQLContext

val vc = new SapSQLContext(sc)

val testsql = ("""

drop table if exists nameinfo""")

vc.sql(testsql)

val testsql1 = ("""

CREATE TABLE nameinfo(id int, name string)

USING com.sap.spark.vora

OPTIONS (

format "csv",

csvdelimiter ",",

files "/user/vora/Customer_data.csv"

)""").stripMargin

vc.sql(testsql1)

we are unable to create a table and we are getting the following issue:

(ref vora-issuelog.png attachement) vora-v2server-log.txt

After freeing the buffer there’s nothing happening in the shell and the table doesn’t get created.

But if we create a table using this query,

import org.apache.spark.sql.SapSQLContext

val vc = new SapSQLContext(sc)

val testsql = ("""

drop table if exists nameinfo""")

vc.sql(testsql)

val testsql1 = ("""

CREATE TABLE nameinfo(id int, name string)

USING com.sap.spark.vora

vc.sql(testsql1)

The table gets created. Hence we are unable to create table using Options() constructor with files loading from hdfs.

The same issue goes with both Vora UI sql editor as well with Vora spark shell.