Re: Hive Table not from from Spark SQL

2015-03-27 Thread ๏̯͡๏
I tried the following 1) ./bin/spark-submit -v --master yarn-cluster --driver-class-path

Re: Hive Table not from from Spark SQL

2015-03-27 Thread Denny Lee
Upon reviewing your other thread, could you confirm that your Hive metastore that you can connect to via Hive is a MySQL database? And to also confirm, when you're running spark-shell and doing a show tables statement, you're getting the same error? On Fri, Mar 27, 2015 at 6:08 AM ÐΞ€ρ@Ҝ (๏̯͡๏)

Re: Hive Table not from from Spark SQL

2015-03-26 Thread ๏̯͡๏
I have tables dw_bid that is created in Hive and has nothing to do with Spark. I have data in avro that i want to join with dw_bid table, this join needs to be done using Spark SQL. However for some reason Spark says dw_bid table does not exist. How do i say spark that dw_bid is a table created

Re: Hive Table not from from Spark SQL

2015-03-26 Thread ๏̯͡๏
I have this query insert overwrite table sojsuccessevents2_spark select guid,sessionKey,sessionStartDate,sojDataDate,seqNum,eventTimestamp,siteId,successEventType,sourceType,itemId, shopCartId,b.transaction_Id as transactionId,offerId,b.bdr_id as

Hive Table not from from Spark SQL

2015-03-26 Thread ๏̯͡๏
I have a hive table named dw_bid, when i run hive from command prompt and run describe dw_bid, it works. I want to join a avro file (table) in HDFS with this hive dw_bid table and i refer it as dw_bid from Spark SQL program, however i see 15/03/26 00:31:01 INFO HiveMetaStore.audit:

Re: Hive Table not from from Spark SQL

2015-03-26 Thread Michael Armbrust
What does show tables return? You can also run SET optionName to make sure that entries from you hive site are being read correctly. On Thu, Mar 26, 2015 at 4:02 AM, ÐΞ€ρ@Ҝ (๏̯͡๏) deepuj...@gmail.com wrote: I have tables dw_bid that is created in Hive and has nothing to do with Spark. I have

Re: Hive Table not from from Spark SQL

2015-03-26 Thread ๏̯͡๏
Hello Michael, Thanks for your time. 1. show tables from Spark program returns nothing. 2. What entities are you talking about ? (I am actually new to Hive as well) On Thu, Mar 26, 2015 at 8:35 PM, Michael Armbrust mich...@databricks.com wrote: What does show tables return? You can also run

Re: Hive Table not from from Spark SQL

2015-03-26 Thread ๏̯͡๏
Stack Trace: 15/03/26 08:25:42 INFO ql.Driver: OK 15/03/26 08:25:42 INFO log.PerfLogger: PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver 15/03/26 08:25:42 INFO log.PerfLogger: /PERFLOG method=releaseLocks start=1427383542966 end=1427383542966 duration=0