"Turn" Cloudera Hue issues

Turn from http://molisa.iteye.com/blog/1953390 I am mainly adjusting the time zone problem of hue according to this instructions

There was a problem when using Cloudera hue:
1. When using the Sqoop import function, the "Save Run" job does not commit properly due to configuration errors, and there is no prompt on the interface:

• Sqoop shell with Hue-"Start job--jid * Submit some error prompts
• And then go to/var/log/sqoop/and check the log.

2. The second issue is the use of the job designer to design the Sqoop task, when submitted, the execution of the process prompted the lack of MySQL driver, although the driver has been added to the Sqoop/lib, and later found that the original installation will be Oozie Workflow shared dependent packages into HDFs, so I upload the driver to hdfs://user/oozie/share/lib/sqoop/and then execute the job.

3. Hue Oozie executes Sqoop create-hive-table, cannot successfully create table in hive Metastore, although Sqoop parameter is added to--verbose, the DDL statement representing the table to be created is displayed during execution , but show tables in hive, and did not really create success. The initial findings may be that there is no way to invoke the hive client in hue, because the log generated by hive was not printed at the end of the Sqoop.

4. There are several settings for time in Hue Oozie, which are related to timezone:

• The settings for the time zone of Hue in Cloudera Manager, which defaults to American/losangeles, make the time display for tasks in Hue Oozie dashboard not consistent with Chinese standard time and changed to asia/ Chongqing, restart the Hue service.
• Hue Oozie Coordinator's frequency setting, the time zone setting after the start and end times, is used to adjust the DST area. Due to daylight saving time in some time zones, the start and end times must be adjusted.
• The above start and end Times use the UTC time zone, which can change the oozie.process.timezone in/etc/oozie/conf/oozie-default.xml and the default is UTC. Then, hue Oozie changes to this setting do not work, so when using Hue Oozie, set the time fixed to UTC as the benchmark, China time is 8 hours earlier, generally minus 8 hours.

5. When MySQL is used as the database for the Metastore and Cloudera Manager Monitor service of Hive in the cluster, each node installs Mysql-connector.

6. When deploying Hadoop with Cloudera Manager, the use of NTP server/client resolves this problem because the node clocks are not uniform, causing the service to become abnormally.

7. Cloudera Manager-hbase Browser couldn ' t connect to localhost:9090

In Hue 2.5.0, there is a new feature called "HBase Browser", it's for user to quickly browsing huge tables and accessing Hbase content. You can also create new tables, add data, modify existing cells and filter data with the autocompleting search bar. If you click on the "Hbase Browser" icon and get "API error:couldn ' t connect to localhost:9090", probably you don't have a Hb ASE Thrift server running.

In your CM, go to ' all Services ', ' hbase1 ', ' Instances ', then under ' Role Instances ', click on ' Add ', choose a n Ode to IS "HBase Thrift server", then start the Thrift server. By default, Hue connects to itself in Port 9090, so make sure Hue knows which node is the thrift server.

To start a thrift server from Commnad line, just type "hbase thrift Start".

"Turn" Cloudera Hue issues