[jira] [Created] (ZEPPELIN-381) sqlContext doesn't work with tables created by external jars (e.g. com.databricks.spark.csv)

[Tomas Hudik (JIRA)]

Tomas Hudik created ZEPPELIN-381:
------------------------------------

             Summary: sqlContext doesn't work with tables created by external 
jars (e.g. com.databricks.spark.csv)
                 Key: ZEPPELIN-381
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-381
             Project: Zeppelin
          Issue Type: Bug
          Components: Core
    Affects Versions: 0.6.0
            Reporter: Tomas Hudik


this works fine:
{code}
%dep
z.load("com.databricks:spark-csv_2.10:1.2.0")
{code}

{code}
val df = sqlContext.load("com.databricks.spark.csv", Map("path" -> 
"bank-full.csv","header"->"true","delimiter"->";"))
df.registerTempTable("bank")
{code}

however, when I try to do select in SQL interpreter I got error:
{code}
%sql
select age, count(1) from hmm where age < 30 group by age order by age
{code}
{code}
java.lang.ClassNotFoundException: 
com.databricks.spark.csv.CsvRelation$$anonfun$tokenRdd$1$$anonfun$1 at 
java.net.URLClassLoader.findClass(URLClassLoader.java:381) at 
java.lang.ClassLoader.loadClass(ClassLoader.java:424) at 
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331) at 
java.lang.ClassLoader.loadClass(ClassLoader.java:357)
{code}

Question: if temp table is registered why Sql command still requires it?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)