Re: Loading already existing tables in spark shell

2015-08-25 Thread Ishwardeep Singh
e: Loading already existing tables in spark shell In spark shell "use database " not working saying use not found in the shell? did you ran this with scala shell ? On 24 August 2015 at 18:26, Ishwardeep Singh mailto:ishwardeep.si...@impetus.co.in>> wrote: Hi Jeetendra, I faced thi

Re: Loading already existing tables in spark shell

2015-08-25 Thread Jeetendra Gangele
lease set the database by using "use " command before > executing the query. > > > Regards, > > Ishwardeep > > -- > *From:* Jeetendra Gangele > *Sent:* Monday, August 24, 2015 5:47 PM > *To:* user > *Subject:* Loading already ex

RE: Loading already existing tables in spark shell

2015-08-24 Thread Cheng, Hao
And be sure the hive-site.xml is under the classpath or under the path of $SPARK_HOME/conf Hao From: Ishwardeep Singh [mailto:ishwardeep.si...@impetus.co.in] Sent: Monday, August 24, 2015 8:57 PM To: user Subject: Re: Loading already existing tables in spark shell Hi Jeetendra, I faced

Re: Loading already existing tables in spark shell

2015-08-24 Thread Ishwardeep Singh
5:47 PM To: user Subject: Loading already existing tables in spark shell Hi All I have few tables in hive and I wanted to run query against them with spark as execution engine. Can I direct;y load these tables in spark shell and run query? I tried with 1.val sqlCon

Loading already existing tables in spark shell

2015-08-24 Thread Jeetendra Gangele
Hi All I have few tables in hive and I wanted to run query against them with spark as execution engine. Can I direct;y load these tables in spark shell and run query? I tried with 1.val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc) 2.qlContext.sql("FROM event_impressions select count