This problem was caused because the Sqoop tables hadn't been created in PostgreSQL. To solve this problem, please go to CM > Sqoop 2 service, click on Actions button and then choose "Create Sqoop Database". After that, please try to start Sqoop2 service again. ... View more

Hello, In CDH 5.8, queries can be exported from a user's home directory and imported to another users in JSON format. Steps bellow 1. Go to "my documents" on old user. (house icon) 2. Select the queries you would like to export. If they're in a folder, you can export the whole folder or use "cntrl click" to select multiple queries. Another option is to drag select them. 3. Click the "download" icon on the action bar at the top of the file browser. This will download the queries as a json file or multiple json files. 4. Log into the new account and go to "my documents" house icon. 5. Click the "upload" icon in the action bar. 6. Select a json file in the file browser. json files can only be uploaded one at a time. 7. Click import to finish the process. ... View more

Please use the impala jdbc not hive jdbc like this: [root@nightly59-unsecure-3 ~]# mkdir -p /root/impala-jdbc/jdbc [root@nightly59-unsecure-3 ~]# hadoop classpath /etc/hadoop/conf:/opt/cloudera/parcels/CDH-5.9.3-1.cdh5.9.3.p0.56/lib/hadoop/libexec/../../hadoop/lib/*:/opt/clo... [root@nightly59-unsecure-3 ~]# cd /root/impala-jdbc/jdbc/ [root@nightly59-unsecure-3 jdbc]# ll total 13584 -rwxr-xr-x 1 root root 1554773 Apr 10 23:46 ImpalaJDBC4.jar -rwxr-xr-x 1 root root 1307923 Apr 10 23:46 TCLIServiceClient.jar -rwxr-xr-x 1 root root   46725 Apr 10 23:45 commons-codec-1.3.jar -rwxr-xr-x 1 root root   60686 Apr 10 23:45 commons-logging-1.1.1.jar -rwxr-xr-x 1 root root 7670596 Apr 10 23:45 hive_metastore.jar -rwxr-xr-x 1 root root  596600 Apr 10 23:45 hive_service.jar -rwxr-xr-x 1 root root  352585 Apr 10 23:46 httpclient-4.1.3.jar -rwxr-xr-x 1 root root  181201 Apr 10 23:46 httpcore-4.1.3.jar -rwxr-xr-x 1 root root  275186 Apr 10 23:46 libfb303-0.9.0.jar -rwxr-xr-x 1 root root  347531 Apr 10 23:46 libthrift-0.9.0.jar -rwxr-xr-x 1 root root  367444 Apr 10 23:46 log4j-1.2.14.jar -rwxr-xr-x 1 root root  294796 Apr 10 23:46 ql.jar -rwxr-xr-x 1 root root   23671 Apr 10 23:46 slf4j-api-1.5.11.jar -rwxr-xr-x 1 root root    9693 Apr 10 23:46 slf4j-log4j12-1.5.11.jar -rwxr-xr-x 1 root root  792964 Apr 10 23:46 zookeeper-3.4.6.jar [root@nightly59-unsecure-3 jdbc]# export HADOOP_CLASSPATH=`hadoop classpath`:/opt/cloudera/parcels/CDH-*/lib/hive/lib:/root/impala-jdbc/jdbc/* [root@nightly59-unsecure-3 jdbc]# beeline beeline> !connect 'jdbc:impala://nightly59-unsecure-3.gce.cloudera.com:21050;AuthMech=0' Connecting to jdbc:impala://nightly59-unsecure-3.gce.cloudera.com:21050;AuthMech=0 Enter username for jdbc:impala://nightly59-unsecure-3.gce.cloudera.com:21050;AuthMech=0: Enter password for jdbc:impala://nightly59-unsecure-3.gce.cloudera.com:21050;AuthMech=0: Connected to: Impala (version 2.7.0-cdh5.9.x) Driver: ImpalaJDBC (version 02.05.37.1057) Error: [Simba][JDBC](11975) Unsupported transaction isolation level: 4. (state=HY000,code=11975) 0: jdbc:impala://nightly59-unsecure-3.gce.clo> show tables; +------------+--+ |    name    | +------------+--+ | customers  | | sample_07  | | sample_08  | | web_logs   | +------------+--+ 4 rows selected (0.177 seconds) 0: jdbc:impala://nightly59-unsecure-3.gce.clo> select * from customers limit 5; +--------+---------------------+--+ |   id   |        name         | +--------+---------------------+--+ | 75012  | Dorothy Wilk        | | 17254  | Martin Johnson      | | 12532  | Melvin Garcia       | | 42632  | Raymond S. Vestal   | | 77913  | Betty J. Giambrone  | +--------+---------------------+--+ 5 rows selected (0.523 seconds) For the detail information, please check this document. https://www.cloudera.com/documentation/enterprise/latest/topics/impala_jdbc.html ... View more