I am not a hive expert and know enough on this. Give it a shot and post back the result. I am sure experts will help. Best Ayan On 17 May 2015 02:40, "Sourav Mazumder" <[email protected]> wrote:
> Hi Ayan, > > Thanks for your response. > > In my case the constraint is I have to use Hive 0.14 for some other > usecases. > > I believe the incompatibility is at the thrift server level (the > hiveserver 2 which comes with hive). If I use Hive 0.13 hiverserver 2 in > the same node as of spark master should that help ? > > Regards, > Sourav > > On Sat, May 16, 2015 at 8:48 AM, ayan guha <[email protected]> wrote: > >> Hi >> >> Try with Hive 0.13. If I am not wrong, Hive 0.14 is not supported yet, >> definitely not with 1.2.1 :) >> >> On Sun, May 17, 2015 at 1:14 AM, smazumder <[email protected]> >> wrote: >> >>> HI, >>> >>> I'm trying to execute simple sql statement from spark-shell >>> >>> val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc) - This one >>> executes properly. >>> >>> Next I'm trying - >>> sqlContext.sql("CREATE TABLE IF NOT EXISTS src (key INT, value STRING)") >>> >>> This keeps on trying to connect Metastore but could nener. The error I'm >>> getting is - >>> >>> Trying to connect to metastore with URI thrift://<host-name>.com:9083 >>> set_ugi() not successful, Likely cause: new client talking to old server. >>> Continuing without it. >>> org.apache.thrift.transport.TTransportException: >>> java.net.SocketException: >>> Connection reset >>> >>> Any idea ? >>> >>> I'm using Spark 1.2.1 and Hive is 0.14. >>> >>> Regards, >>> Sourav >>> >>> >>> >>> >>> -- >>> View this message in context: >>> http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-is-not-able-to-connect-to-hive-metastore-tp22916.html >>> Sent from the Apache Spark User List mailing list archive at Nabble.com. >>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> >> >> -- >> Best Regards, >> Ayan Guha >> > >
