Member since
10-30-2016
2
Posts
0
Kudos Received
0
Solutions
10-31-2016
03:47 AM
To check if it's a Spark config problem,I started the spark-shell and did the following sql("CREATE TABLE testing_table (col1 String, col2 Timestamp) STORED AS ORC") sql("select * from testing_table") It worked fine but same thing did not work through Spark notebook in hue.It gave me the same error as mentioned above.
... View more
10-30-2016
05:39 AM
I have set-up hue 3.11 and Spark Notebook is working fine with Spark-2.0.0 through livy server. I am able to create DF's,Datasets etc through tthe notebook. I have a hiveserver 2 running on same machine where hue is installed. I have placed the hive-site.xml in spark/conf directory.Also I have specified metastore directory in spark-deafult.conf as /user/hive/warehouse. When I do saveAsTable on a DF,no error come's up.It say's done.df.saveAsTable("test") But when I do a select on the same table using spark.sql("select * from test") or sql("select * from test"). An error shows up saying "Hive support is required to do select on the following table default.test" What could be wrong here?
... View more