Hi Su,
it seems like your table is not getting registered.
can you try the following:if you have used the following line
"val sqlContext = new org.apache.spark.sql.SQLContext(sc)"
I would suggest to comment it, as zeppelin creates sqlContext byDefault.
if you didnt have the above line do write following lines at the end of
paragraph and run:
sqlContext.tableNames().foreach(println) // this should print all the tables
register with current sqlContext on output section.
you can also check you spark version by running following commandsc.version
-Nihal
On Wednesday, 17 June 2015 10:01 AM, Su She <suhsheka...@gmail.com> wrote:
Hello,
excited to get Zeppelin up and running!
1) I was not able to go through the Zeppelin tutorial notebook. I did
remove toDF which made that paragraph work, but the 3 graphs at the
bottom all returned the InvocationTargetException
2) From a couple other threads on the archive it seems like this error
means that it isn't connected to Spark:
a) I am running it locally
b) I created a new notebook and I was able to run spark commands and
create a table using sqlContext and query it, so this means that it is
connected to Spark right?
c) I am able to do:
val results = sqlContext.sql("SELECT * FROM wiki")
but i can't do:
%sql select pagecounts, count(1) from wiki
3) I am a bit confused on how to get the visualizations. I understand
the %table command, but do I use %table when running Spark jobs or do
I use %sql?
Thanks!
-Su
