@mfulwiler     Go to Cloudera Manager -> Hue -> Configuration -> Impala Service -> Pls make sure it is enabled   Also Please make sure that you meet the "Configuring Impala Delegation for Hue and BI Tools" details mentioned in the below link   https://www.cloudera.com/documentation/enterprise/5-5-x/topics/impala_authentication.html     ... View more

@mfulwiler   As you have access via CLI but getting issue only in Hue, it should be permission setup issue in Hue againts your user id.   You can try this: Hue -> Login as admin user (top right drop down and choose as admin) -> Permissions tab -> choose the required services like impala, etc against your user id     ... View more

@Iron   I don't think it is mandatory to enable the safemode during copyToLocal. May be you can use safemode to make sure nobody is updating/deleting/inserting the data during the data copy.   I know the difficulties without cloudera manager/hortonworks, etc   Long back, i've used the below export/import method for Hive table backup, again this will export the data to HDFS and you still have to use copyTolocal. The advantage is, it will also take care of metadata   https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport#LanguageManualImportExport-ExportSyntax   You can use these options as temporary solution but once you start using cloudera manager or any other management tool, I would recommend to use the backup option that i've mentioned earlier ... View more

@rrodriguez   Is it? my bad, i didn't get it... Did you get a chance to follow 'all' the steps that i've mentioned? if so, were you able to run all the steps successfully? ... View more

@rrodriguez happy to know that it worked!! ... View more

@ivten   Having two mysql databases are common in the cluster where you have HA setup for MySQL. It works as master/slave... with that said, you have to apply the required setting in both the mysql databases.   Note: Here i've mentioned the standard method. Please make sure they are master & slave by running the following commands.    login as root to mysql and run  show slave status\G; show master status\G; ... View more

@Szczechla   The similar issue (Resource temporarily unavailable error message from Impala shell) has been discussed in the below link. It may help you.   Note: Your log shows the issue is due to Resource temporarily unavailable    https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Resource-temporarily-unavailable-error-message-from-Impala-shell/td-p/27473 ... View more

@Saca   The following Impala keywords are not supported for Kudu tables: PARTITIONED STORED AS LOCATION ROWFORMAT Pls refer the link https://www.cloudera.com/documentation/kudu/0-5-0/topics/kudu_impala.html#concept_r3t_vtz_kt__section_ubx_shb_ht   To create table from impala https://www.cloudera.com/documentation/kudu/0-5-0/topics/kudu_impala.html#concept_g51_5vk_ft   Please make sure to meet the pre-request ... View more

@rrodriguez   1. Get the node has keytab. Ex: I am using the node which belongs to impala daemon. 2. Go to /var/run/cloudera-scm-agent/process and ls, it will list the process 3. cd xxxxxx-impala-IMPALAD .. ## Run ls cmd and make sure it has impala.keytab 4. klist -kt impala.keytab ## This will list all the available and valid principals 5. kinit -kt impala.keytab <copy paste the valid principal from the above step> 6. klist ## make sure kinit initiated ... View more