Cloudera Community
scratch28
user rank
Contributor

Re: hbase Master failed to become active master

by Expert Contributor Expert Contributor in Support Questions
‎02-08-2019 05:06 AM
‎02-08-2019 05:06 AM
Not sure which version of CDH you met with this issue. Note that the hbase namespace table is a system table required for HBase to function properly.  This table is not handled with a higher priority than other tables as noted in HBASE-14190. If the HBase Master tries to split a WALs on dead or ghost Region Servers then the HBase Master might get stuck trying to split these WALs on invalid Region Servers. The HBase Master can also get stuck trying to split corrupt 83-byte or smaller WAL files on startup in which case just sidelining those blocking WAL files would help. So increasing the hbase.master.namespace.init.timeout may or may not help depending on whether the Master is stuck with any other tasks like WAL splitting.   Another workaround is to recreate the hbase:namespace table in which case it will get loaded quickly. ... View more

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: How do I see user usage stats by table in Impa...

by Champion in Support Questions
‎07-19-2018 02:30 AM
‎07-19-2018 02:30 AM
@scratch28   You can use clouder navigator to generate this report   Login as full admin to CM    Cloudera Management Service -> Navigator Metadata Server -> Cloudera Navigator (menu) -> search for 'impala' -> choose from left side options. You can choose upto last 365 days (or) custom period ... View more

Re: Impala refresh took over 36385 seconds to comp...

by Contributor in Support Questions
‎03-27-2018 06:26 PM
‎03-27-2018 06:26 PM
10 hours is a long time for a refresh. Since this is a partitoned table, if you know the partitions being added then you could use the new "refresh table ... partition ..." syntax to only look at those partitons.   Alternatively, recover partitions is faster than refresh for partitioned tables if you're only adding new partitions (vs. updating existing ones): https://www.cloudera.com/documentation/enterprise/5-11-x/topics/impala_refresh.html   Regards, Mark ... View more

Re: HUE not showing databases or tables

by New Contributor in Support Questions
‎01-15-2018 02:12 PM
1 Kudo
‎01-15-2018 02:12 PM
1 Kudo
For issue : Hue not showing hbase tables, we needs to give grant privilage to hue user in hbase shell. take kerberos authentication using hbase keytab. then start hbase shell & use below command. grant 'hue', 'RWXC' Now you will find that hbase tables are showing in hue. same process is for hive also. ... 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

Re: HUE no longer sees impala or have after restar...

by Contributor in Support Questions
‎04-05-2017 06:57 PM
‎04-05-2017 06:57 PM
Fixed Romain posted on Hue user group that I had a conflict in python libraries and indeed I did I had Impyla and Airflow installed as part of the main lib/distro instead of a controlled "virtualized" environment This caused the  conflict.     Unfortunately both Impyla and Airflow could not be uninstalled with a simple pip uninstall command Had to manually compare directories from my staging environment and remove several of the directories that could be potentially conflicting These include: hive_metastore hive_thrift_py pyhive hive_serde impala PyHive TCLIService hive_service impyla thrift Once the directories where removed from /usr/local/lib/python2.7/dist-packages and restarted HUE, it was querying again.    Many kudos to Romain ... View more

Re: Sentry No valid privileges Required privileges...

by Contributor in Support Questions
‎03-30-2017 05:03 PM
1 Kudo
‎03-30-2017 05:03 PM
1 Kudo
do you mind expanding on the answer a bit I have the same problem  is the group setting in CM or on hdfs or os files system?   ... View more

Re: unhex in Impala

by Cloudera Employee in Support Questions
‎06-21-2016 11:54 AM
‎06-21-2016 11:54 AM
Unfortunately there doesn't seem to be a function that does this. If you are familiar with Java or C++, writing a UDF shouldn't be too hard. UDF documentation is at http://www.cloudera.com/documentation/enterprise/latest/topics/impala_udf.html and of course if you have questions we can help you here. ... 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