Running Hive Beeline .hql file in Spark

2017-01-24 Thread Ravi Prasad
Hi , Currently we are running Hive Beeline queries as below. *Beeline :-* beeline -u "jdbc:hive2://localhost:1/default;principal=hive/_HOST@ nsroot.net" --showHeader=false --silent=true --outputformat=dsv --verbose =false -f /home/*sample.hql *> output_partition.txt Note : We run the

Running Hive Beeline .hql file in Spark

2017-01-20 Thread Ravi Prasad
Hi , Currently we are running Hive Beeline queries as below. *Beeline :-* beeline -u "jdbc:hive2://localhost:1/default;principal=hive/_ h...@nsroot.net" --showHeader=false --silent=true --outputformat=dsv --verbose =false -f /home/*sample.hql *> output_partition.txt Note : We run the

Re: Writing Spark SQL output in Local and HDFS path

2017-01-19 Thread Ravi Prasad
he delimiter as "|". > > We tried with the below code > result.saveAsTextFile ("home/Prasad/result.txt") > It is not working as expected. > > > -- > -- > Prasad. T > -- -- Regards, RAVI PRASAD. T

Writing Spark SQL output in Local and HDFS path

2017-01-19 Thread Ravi Prasad
Hi, Can anyone please let us know how to write the output of the Spark SQL in Local and HDFS path using Scala code. *Code :-* scala> val result = sqlContext.sql("select empno , name from emp"); scala > result.show(); If I give the command result.show() then It will print the output in the

Which version of Hive support Spark Shark

2014-07-03 Thread Ravi Prasad
Hi , Can any one please help me to understand which version of Hive support Spark and Shark -- -- Regards, RAVI PRASAD. T