Zeppelin Tutorial and using Hive Context

[Su She <su...@gmail.com>]

Hello!

I have three questions:

1) I somehow lost the Zeppelin tutorial notebook and I was wondering if
there's a copy of it somewhere I could find? Or if someone could provide
the details? I know the tutorial has part of it, but not all of it.

2) I am getting this error when i am trying the following:

import sys.process._
import org.apache.spark.sql.hive._
val hc = new HiveContext(sc)

hc.sql("CREATE TABLE IF NOT EXISTS src (key INT, value STRING)")

org.apache.spark.sql.execution.QueryExecutionException: FAILED: Execution
Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
MetaException(message:file:/user/hive/warehouse/src is not a directory or
unable to create one)

So I changed the permissions on /user/hive/ to allow other to r/w/x, so I
don't think its a permission issue. Is it trying to write
file:/user/hive/warehouse/src to the local instance or HDFS? It seems it is
trying to write to local and that might be the issue.

3) Given the error above, can I create a table with Hive Context like I
would normally do in hive based of data in HDFS?

Thank you!

Best,

Su