You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@zeppelin.apache.org by "Tomas Hudik (JIRA)" <ji...@apache.org> on 2015/10/31 21:57:27 UTC
[jira] [Created] (ZEPPELIN-381) sqlContext doesn't work with tables
created by external jars (e.g. com.databricks.spark.csv)
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)