Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (2)
Contributor

Error:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '115' for key 'PRIMARY'

ROOT CAUSE: corrupted ambari db-- seeing following errors in Hive View Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '115' for key 'PRIMARY' SOLUTION: we truncated the following tables from amabri db

DS_FILERESOURCEITEM_1 |

| DS_JOBIMPL_3 |

| DS_SAVEDQUERY_6 |

| DS_STOREDOPERATIONHANDLE_5 |

| DS_TESTBEAN_4 |

| DS_UDF_2

Restart ambari server and we are able to access views and run query

510 Views
0 Kudos
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎12-31-2016 09:21 PM
Updated by:
 
Contributors
Top Kudoed Authors