Cloudera Community
scratch28
user rank
Contributor

Re: Adding Impala to HUE

by Contributor in Support Questions
‎10-29-2018 12:45 PM
‎10-29-2018 12:45 PM
I had to customize Hue Server Advanced Configuration Snippet (Safety Valve) for hue_safety_valve_server.ini to add back the base functionality [notebook] [[interpreters]] [[[hive]]] name=Hive interface=hiveserver2 [[[impala]]] name=Impala interface=hiveserver2 [[[presto]]] name=Presto interface=jdbc options='{"url": "jdbc:presto://ta-pci-prod-presto-master01.tripactions.local:8889/ta", "driver": "com.facebook.presto.jdbc.PrestoDriver"}' ... View more

Re: Hive not available in HUE

by Contributor in Support Questions
‎10-29-2018 11:42 AM
‎10-29-2018 11:42 AM
I had to customize  Hue Server Advanced Configuration Snippet (Safety Valve) for hue_safety_valve_server.ini to add back the base functionality  [notebook] [[interpreters]] [[[hive]]] name=Hive interface=hiveserver2 [[[impala]]] name=Impala interface=hiveserver2 [[[presto]]] name=Presto interface=jdbc options='{"url": "jdbc:presto://ta-pci-prod-presto-master01.tripactions.local:8889/ta", "driver": "com.facebook.presto.jdbc.PrestoDriver"}' ... View more

Re: Hive not available in HUE

by Contributor in Support Questions
‎10-26-2018 03:19 PM
‎10-26-2018 03:19 PM
sure  I should be able to see both Hive and HUE on this drop down see attached and yes it is activated   ... View more

Adding Impala to HUE

by Contributor in Support Questions
‎10-26-2018 01:25 PM
‎10-26-2018 01:25 PM
I added Impala as a service after the installation of CDH6    Impala via commandline on the box works but it doesn't work in HUE I followed the instructions  per the documents and  and from here  https://community.cloudera.com/t5/Web-UI-Hue-Beeswax/Do-not-see-impala-app-in-hue-after-installation-of-impala/m-p/63267/highlight/true#M2560   According to @Romainr I need to add  the following to the HUE.ini   [[[impala]]] name=Impala interface=hiveserver2  Every time I add something to  Hue Service Advanced Configuration Snippet (Safety Valve) for hue_safety_valve.ini and try to restart the service the service refuses to start   am I not putting the condition in the right place or in the right format?   It suppose to be a simple change from None to Impala and it should work   ... View more

Hive not available in HUE

by Contributor in Support Questions
‎09-18-2018 03:38 PM
‎09-18-2018 03:38 PM
On CMS 6 (playing around with it )  and I configured HUE but Hive is not available  The only option is  Hive Service Hue (Service-Wide)   Hive am I missing something? ... View more
Labels:

How do I see user usage stats by table in Impala Q...

by Contributor in Support Questions
‎07-18-2018 11:11 AM
‎07-18-2018 11:11 AM
Is there a Chart or way to see all the tables used by Impala for the last 6 months? I know that in CM the Queries tab shows only 30 days of prior queries is there a chart I can build out? ... View more

Impala refresh took over 36385 seconds to complete...

by Contributor in Support Questions
‎02-06-2018 10:32 AM
‎02-06-2018 10:32 AM
  We are on Impala Shell v2.8.0-cdh5.11.1 community edition SSL is enabled but no sentry Executed a command refresh schema.table    17:15:14 Query: refresh hbasestage.raw_transactions 17:15:14 Query submitted at: 2018-02-06 01:15:14 (Coordinator: http://hadoop4-private.wdc01.infra.ripple.com:25000) 03:21:40 Query progress can be monitored at: http://hadoop4-private.wdc01.infra.ripple.com:25000/query_plan?query_id=984250bf5d880d33:fddc42d100000000 03:21:40 03:21:40 Fetched 0 row(s) in 36385.13s There has to be a better way   Table is normally populated by Hive, so refresh is required for impala to recognize new partitions Table has 1861 partitions - total 1.28 TB of data, each partition is no bigger than 3GB (partition is by date) Files are avro but that shouldn't impact it (should it?) Yarn does NOT manage resources ... View more
Labels:

Re: hbase Master failed to become active master

by Contributor in Support Questions
‎08-17-2017 09:20 AM
‎08-17-2017 09:20 AM
Another update left master alone to see if it can resolve Starting namespace manager (since 11hrs, 55mins, 3sec ago) unfortunately I cannot find any logs on what exactly its trying to do   ... View more

Re: hbase Master failed to become active master

by Contributor in Support Questions
‎08-16-2017 04:23 PM
‎08-16-2017 04:23 PM
add on https://issues.apache.org/jira/browse/HBASE-16488  and master is still starting  Starting namespace manager (since 1hrs, 55mins, 57sec ago) ... View more

Re: Impala running slow after upgrade

by Contributor in Support Questions
‎08-16-2017 03:55 PM
‎08-16-2017 03:55 PM
Agent and edge node where HUE was running was not upgraded  ... View more
Contact Me
Online
Offline
Last Visited
‎01-14-2019 03:17 PM
Community Statistics
Member Since ‎10-15-2014 04:20 PM
Last Visited ‎01-14-2019 03:17 PM
Posts 126
Kudos received 2