Guillaume created AMBARI-18598:
----------------------------------
Summary: S020 error with Hive view and Mysal
Key: AMBARI-18598
URL: https://issues.apache.org/jira/browse/AMBARI-18598
Project: Ambari
Issue Type: Bug
Components: ambari-server
Affects Versions: 2.4.1
Environment: centos 7, HDP2.5
Reporter: Guillaume
Using hdp2.5 (ambari 2.4.1) with a Hive view, a table has been created by an
external tool (hdfs connector from confluent.io). I can see the table metadata
(column names and type) but trying to get data gives me the error:
{quote}
S020 Data storage error
[blahblah]
Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002]
(Eclipse Persistence Services - 2.6.2.v20151217-774c696):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'ambari.DS_JOBIMPL_4' doesn't exist
Error Code: 1146
[a lot more lines]
{quote}
Now I saw another answer giving a cut&paste solution. This does not work for
me, as I then end up with a different error:
{quote}
S020 Data storage error
[blahblah]
Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002]
(Eclipse Persistence Services - 2.6.2.v20151217-774c696):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 'DS_guid' in 'field list'
Error Code: 1054
[a lot more lines]
{quote}
It looks to me like the answer is out of date.
I suppose the original reason still holds:
bq. ROOT CAUSE: This is a limitation with the Mysql DB itself with varchar
accounting to more than 75000 maximum row size where as the mysql DB can accept
only 65535 as its max value.
But I would love to understand a few things:
* Why does this still happen (I have seen a few commits already in ambari
trying to fix this)
* How can I regenerate the relevant CREATE statement
* Why sometimes is it DS_JOBIMPL_4, sometimes DS_JOBIMPL_8 and how can I be
sure that I am creating the right tables
* In which log file can I find the relevant failded CREATE statement
* Is there a way to fully avoid this
That's a lot of questions but it always happened to me, no matter which HDP
version so I would really love to go to the bottom of it.
Thanks,
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
