Member since
11-07-2016
637
Posts
253
Kudos Received
144
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1829 | 12-06-2018 12:25 PM | |
1747 | 11-27-2018 06:00 PM | |
1335 | 11-22-2018 03:42 PM | |
2349 | 11-20-2018 02:00 PM | |
4077 | 11-19-2018 03:24 PM |
12-07-2017
02:08 PM
1 Kudo
@Gerald BIDAULT, You should not see any issue with other services managed by Ambari. The SmartSense Id and other fields will be populated as unspecified. Other services should work fine as expected. You can see more about SmartSense here Thanks, Aditya
... View more
12-07-2017
10:58 AM
1 Kudo
@Gayathri Devi, Can you try this query insert into table tblename select * from (select from_unixtime(unix_timestamp('161223000001', 'yyMMddHHmmss')))b; #2) If you have timestamp as '1506614501' hive> select from_unixtime(unix_timestamp('1506614501', 'yyMMddHHmm'));
OK
2015-08-01 21:01:00
Time taken: 0.257 seconds, Fetched: 1 row(s)
Thanks, Aditya
... View more
12-05-2017
06:24 PM
@Michael Bronson, I'm sorry. I do not have a setup where I can try this currently. But you can see the error message and delete the rows of a table on which it complains the FK constraint for ex: ERROR: update or delete on table "host_role_command" violates foreign key constraint "fk_execution_command_task_id" on table "execution_command"
DETAIL: Key (task_id)=(5156) is still referenced from table "execution_command". For this error you can run delete from execution_command where task_id=5156;
... View more
12-05-2017
06:13 PM
@Michael Bronson, You have to delete all the rows which have FK constraint in different tables. Then you will be able to delete the host entry
... View more
12-05-2017
05:04 PM
I strongly suggest not to delete/edit entries directly in database. However if you still want to do it at your own risk delete from host_role_command where host_id=351;
Delete from hosts where host_id=351;
... View more
12-05-2017
04:48 PM
@Mike Bit, I thought that you were already using Hiveserver2. 10000 is usually the port for HS2. You can continue to use that. Just change the jar in zeppelin and rerun
... View more
12-05-2017
04:40 PM
@Michael Bronson, If the host deletion was not proper then there can be conflicts. The ambari log below doesn't show any errors. Try restarting ambari server and see if you can proceed further. ambari-server restart
... View more
12-05-2017
04:34 PM
@Mike Bit, For #2, Yes. you can use hive server2 For #3, I'm not 100% sure about that. But you can give it a try
... View more
12-05-2017
04:08 PM
@Michael Bronson, It shouldn't take so long. Please check the ambari log to see what is going wrong. Check this file /var/log/ambari-server/ambari-server.log in ambari server node
... View more
12-05-2017
03:52 PM
1 Kudo
@Mike Bit, I'm not sure where the jars are located in a stand alone distribution. You should find it in libs folder. In HDP the jars in the below locations 1)Zeppelin hive jar : /usr/hdp/current/zeppelin-server/interpreter/jdbc/hive-jdbc-1.2.1000.2.6.3.0-235.jar 2) Hive server jdbc jar : /usr/hdp/current/hive-server2/jdbc/hive-jdbc-1.2.1000.2.6.3.0-235-standalone.jar Replace jar in #1 with #2 and restart zeppelin and try running the query
... View more