Member since
04-28-2018
15
Posts
0
Kudos Received
0
Solutions
01-02-2019
05:30 PM
Same issue! thanks Jeroen, and Happy new year !
... View more
12-15-2018
09:29 AM
@Eugene Koifman managed table. format of the 2 files in there (small table for test) is part0-00000-0000-......-c000.snappy.orc and part1-00000-0000-......-c000.snappy.orc Btw, I'm not creating it in hive - but from spark in zeppelin.
... View more
12-14-2018
06:56 PM
All is in the title 🙂 When I do a select count(*) .... or select distinct <field> ... for instance, no problem. But a select * from..... or select <field> from.... fails with this error. Any clues?? I'm in Sandbox
... View more
Labels:
- Labels:
-
Apache Hive
12-11-2018
07:02 PM
Thanks, @Dongjoon Hyun however my issue is a bit different: the database « default » is where tables are naturally created from spark.sql for instance. But turns out I cannot set the privileges right in ranger so that tables I create can be seen by hiveserver2 so that it can be accessed. On the previous sandbox, it was no issue!
... View more
12-10-2018
06:59 PM
I downloaded sandbox 3.0.1 and using right off the bat. 3 databases exist in Hive: default, sys and a demo retail one.
I create a dummy table in default ("create table test (id STRING)") using spark.sql in zeppelin
the table is created and functional.
now, either using superset (hive view replacement) and setting it up to access hive OR external ODBC with hortonworks hive connector, I can see only the demo retail DB and its tables. default seems empty. On the opposite, if I create a table ("create table test2 (id STRING)") in default from superset, I see it in superset AND in zeppelin/spark. Can someone help me access the tables created from spark.sql from hiveserver2 and superset ? Cheers,
Arnaud
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Spark
12-10-2018
05:28 PM
nope. the web app service keeps on shutting down after a minute (106 Gb memory). but even though, tables need to be accessible to hiveserver 2 and they are not (they were on latest sandbox 2.6.5)
... View more
12-10-2018
07:23 AM
Well, as a matter of fact, it's there in 3.0.1 but the web apps fails after a minute of being launched...
... View more
12-09-2018
05:20 PM
Hi, I just installed HDP sandbox 3.0.1. I was configuring superset (as hive is not avail anymore) and realize that hiveserver 2 or superset cannot see ANY tables under default database... I can see them fine in zeppelin/spark though I urgently need to have this (my tables are under default). This is clearly a privilege issue, but cannot find where/what. Thx, Arnaud
... View more
Labels:
- Labels:
-
Apache Hive
12-09-2018
12:15 AM
Hi Just installed HDP 3.0 and trying to access DAS. the WebApp service stops (silently) after a minute. Any once can help ? Arnaud
... View more
Labels:
- Labels:
-
Hortonworks Data Platform (HDP)
11-28-2018
11:14 AM
Hello! I need to change sqoop log level (too verbose). Where can I do this. I'm using the HDP sandbox 2.6.5 Cheers!
... View more
Labels:
- Labels:
-
Apache Sqoop
04-28-2018
04:37 PM
Hi, I'm using spark2 in Zeppelin. (HDP 2.6.4) I'm loading a csv file with spark.read val test = spark.read .option("header", "false") .option("delimiter", ",") .option("inferSchema", "true") .csv("file:///root/share/test.csv") /root/share/ is a shared folder from host to docker container (virtualbox). it has privileges like dwxrwxr--- Because of the shared folder, I cannot chmod 777 on it (or maybe someone knows how to do this...) Anyways, spark comes back with a permission denied on this forlder/file. Questions: 1. when running such a spark2 request in zeppelin, which permissions are applied? 2. How can I "elevate" these permissions to root (so that access can be made to any folder) Thnaks a lot for your help!
... View more
Labels:
- Labels:
-
Apache Spark
-
Apache Zeppelin