Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-09 Thread Даша Ковальчук
Hello, Ranadip! I tried your solution, but still have no results. Also I didn’t find anything in logs. Kerberos disabled, dfs.permissions = false. Thanks. 2017-06-08 20:52 GMT+03:00 Ranadip Chatterjee : > Looks like your session user does not have the required privileges on

Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-09 Thread Даша Ковальчук
ication is strictly > prohibited. If you have received this communication in error, please notify > us immediately by replying to the message and deleting from your computer. > > > > ---------- > *From:* Даша Ковальчук <dashakovalchu...@gmail.com> >

Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-08 Thread Ranadip Chatterjee
Looks like your session user does not have the required privileges on the remote hdfs directory that is holding the hive data. Since you get the columns, your session is able to read the metadata, so connection to the remote hiveserver2 is successful. You should be able to find more

Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-08 Thread Richard Moorhead
ly by replying to the message and deleting from your computer. From: Даша Ковальчук <dashakovalchu...@gmail.com> Sent: Thursday, June 8, 2017 12:30 PM To: ayan guha Cc: user@spark.apache.org Subject: Re: [Spark Core] Does spark support read from remote Hive server via JDBC The

Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-08 Thread Даша Ковальчук
The result is count = 0. 2017-06-08 19:42 GMT+03:00 ayan guha : > What is the result of test.count()? > > On Fri, 9 Jun 2017 at 1:41 am, Даша Ковальчук > wrote: > >> Thanks for your reply! >> Yes, I tried this solution and had the same result.

Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-08 Thread ayan guha
What is the result of test.count()? On Fri, 9 Jun 2017 at 1:41 am, Даша Ковальчук wrote: > Thanks for your reply! > Yes, I tried this solution and had the same result. Maybe you have another > solution or maybe I can execute query in another way on remote cluster? > >

Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-08 Thread Даша Ковальчук
Thanks for your reply! Yes, I tried this solution and had the same result. Maybe you have another solution or maybe I can execute query in another way on remote cluster? 2017-06-08 18:30 GMT+03:00 Даша Ковальчук : > Thanks for your reply! > Yes, I tried this solution

Re: [Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-08 Thread Vadim Semenov
Have you tried running a query? something like: ``` test.select("*").limit(10).show() ``` On Thu, Jun 8, 2017 at 4:16 AM, Даша Ковальчук wrote: > Hi guys, > > I need to execute hive queries on remote hive server from spark, but for > some reasons i receive only

[Spark Core] Does spark support read from remote Hive server via JDBC

2017-06-08 Thread Даша Ковальчук
Hi guys, I need to execute hive queries on remote hive server from spark, but for some reasons i receive only column names(without data). Data available in table, I checked it via HUE and java jdbc connection. Here is my code example: val test = spark.read .option("url",