Community Articles
Find and share helpful community-sourced technical articles.
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

996 Views
0 Kudos
Take a Tour of the Community
Don't have an account?
Version history
Last update:
‎12-31-2016 09:21 PM
Updated by:
Contributors
Top Kudoed Authors
; ;