BTW, if I do sqlContext.sql("select * from table") in zeppelin, it will
show "org.apache.spark.sql.DataFrame = [... (schema) ...]", but no entries.

On the other hand, the example online (creating a DF using case classes)
works for me...

On Fri, Apr 17, 2015 at 3:30 PM, Xu (Simon) Chen <[email protected]> wrote:

> Hey folks,
>
> I am running the latest zeppelin with spark 1.3 on yarn.
>
> I using sqlContext.avroFile() to load avro files from HDFS, like the
> following:
> val data = sqlContext.avroFile("hdfs://xxx")
> data.count
> data.registerTempTable("table")
>
> Strangely, if I do "%sql select * from table", it shows "no such table
> List(table); line 0 pos 0", as if the registerTempTable command never
> happened. I don't see anything in the log it seems.
>
> Any ideas?
>
> Thanks.
> -Simon
>
>

Reply via email to