Community Articles

Find and share helpful community-sourced technical articles.
Labels (2)
avatar
Rising Star

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

1,355 Views
0 Kudos