It works,thanks for your great help.
On Mon, Mar 30, 2015 at 10:07 PM, Denny Lee wrote:
> Hi Vincent,
>
> This may be a case that you're missing a semi-colon after your CREATE
> TEMPORARY TABLE statement. I ran your original statement (missing the
> semi-colon) and got the same error as you did
Hi Vincent,
This may be a case that you're missing a semi-colon after your CREATE
TEMPORARY TABLE statement. I ran your original statement (missing the
semi-colon) and got the same error as you did. As soon as I added it in, I
was good to go again:
CREATE TEMPORARY TABLE jsonTable
USING org.apa
No luck, it does not work, anyone know whether there some special setting
for spark-sql cli so we do not need to write code to use spark sql? Anyone
have some simple example on this? appreciate any help. thanks in advance.
On Sat, Mar 28, 2015 at 9:05 AM, Ted Yu wrote:
> See
> https://databricks
See
https://databricks.com/blog/2015/03/24/spark-sql-graduates-from-alpha-in-spark-1-3.html
I haven't tried the SQL statements in above blog myself.
Cheers
On Sat, Mar 28, 2015 at 5:39 AM, Vincent He
wrote:
> thanks for your information . I have read it, I can run sample with scala
> or python
thanks for your information . I have read it, I can run sample with scala
or python, but for spark-sql shell, I can not get an exmaple running
successfully, can you give me an example I can run with "./bin/spark-sql"
without writing any code? thanks
On Sat, Mar 28, 2015 at 7:35 AM, Ted Yu wrote:
Please take a look at
https://spark.apache.org/docs/latest/sql-programming-guide.html
Cheers
> On Mar 28, 2015, at 5:08 AM, Vincent He wrote:
>
>
> I am learning spark sql and try spark-sql example, I running following code,
> but I got exception "ERROR CliDriver: org.apache.spark.sql.Ana
I am learning spark sql and try spark-sql example, I running following
code, but I got exception "ERROR CliDriver:
org.apache.spark.sql.AnalysisException: cannot recognize input near
'CREATE' 'TEMPORARY' 'TABLE' in ddl statement; line 1 pos 17", I have two
questions,
1. Do we have a list of the st
I am learning spark sql and try spark-sql example, I running following
code, but I got exception "ERROR CliDriver:
org.apache.spark.sql.AnalysisException: cannot recognize input near
'CREATE' 'TEMPORARY' 'TABLE' in ddl statement; line 1 pos 17", I have two
questions,
1. Do we have a list of the st
