Unbale to access hive view with error "Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '115' for key 'PRIMARY' "

[#1]

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