Logs from HUE and Hive would help. With screenshots, we can only guess what is happening. In any case, you can check two things: 1) Check that Hive Server is running. This is not the case in my opinion because you should get an error in HUE. Just double check it. Impala connects to Hive Metastore, so it is not affected if Hive Server id down. 2) And most likely in my opinion, the users that cannot see databases, are not defined in the server where HiveServer is running. So Hive Server is not able to retrieve users' group and match it with a sentry rule. If you use LDAP/AD probably you have configured sssd (or equivalent) on each host. Check that this service is running and user info is fetched from LDAP/AD. If you have manually created users, then check that group info is correct.   ... View more

The Hive screenshot you provide, does not indicate the problem, because in this screenshot wou have "default" database selected. So the "missing" info below is not regarding databases, but not tables exist in the default database. Can you click on "default" on the top of the red box? It will move you to the upper level. ... View more

That's because the "/tmp" directory in your HDFS does not allow access to hive. In general "/tmp" should have 777 permissions, because most of the services use it as a temp directory to store various info. So, if there is no reason to restrict accesss, the following command will solve your problem. hdfs dfs -chmod 777 /tmp ... View more

I am not sure I understand your request. What I understand: * You have a Java application that writes data to a delimited file. * This file is somehow loaded into Hive (e.g. load data inpath 'file.csv' into table output_table)   And the question is what format to use when writing to file? If this is correct, if you have defined this column as timestamp, then the output should be one of the supported formats of timestamp for Hive https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-TimestampstimestampTimestamps   If you have define it as string/varchar then you can use any format you want and then convert it to seconds from unix epoch in hive by using the built-in functions. ... View more

Hive has builtin function for these conversions: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF   You should give a try to: unix_timestamp(string date, string pattern) Convert time string with given pattern (see [http://docs.oracle.com/javase/tutorial/i18n/format/simpleDateFormat.html]) to Unix time stamp (in seconds), return 0 if fail: unix_timestamp('2009-03-20', 'yyyy-MM-dd') = 1237532400.     Where you can define the pattern of the timestamp you provide (including the timezone info) ... View more

According to ther error you posted, your NameNode is in Safe Mode. There should be an Active Name Node in order to perform any HDFS action. ... View more

Have you tried using "-h clouderam" in your command? Permissions (in MySQL) differ whether you are connected as 'user'@'localhost' or 'user'@'clouderam' By using "-h clouderam" you are connected as 'user'@'clouderam' and you should grant permissions to this user. ... View more

This is a MySQL issue.   Have you checked that mysql is running and you are able to connect? ... View more

Check this out https://www.cloudera.com/documentation/enterprise/5-13-x/topics/cm_ig_create_local_package_repo.html#concept_qqw_ww3_gp It allows you to create a temporary repository without installing any software. Suppose that you have python installed. ... View more