[jira] [Commented] (AMBARI-11788) Views : Data storage error when try to execute some query in hive view

["Hudson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AMBARI-11788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14577734#comment-14577734 ] 

Hudson commented on AMBARI-11788:
---------------------------------

SUCCESS: Integrated in Ambari-trunk-Commit #2858 (See [https://builds.apache.org/job/Ambari-trunk-Commit/2858/])
AMBARI-11788 - Views : Data storage error when try to execute some query in hive view (tbeerbower) (tbeerbower: http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=59fa63f1837bd3a19b2e0a903334cbf0e8c7dd68)
* ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
* ambari-server/src/test/java/org/apache/ambari/server/orm/entities/ViewInstanceEntityTest.java
* ambari-server/src/main/java/org/apache/ambari/server/view/persistence/DataStoreImpl.java
* ambari-server/src/main/java/org/apache/ambari/server/view/ViewRegistry.java
* ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog210.java
* ambari-server/src/test/java/org/apache/ambari/server/upgrade/UpgradeCatalog210Test.java
* ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql
* ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
* ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
* ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
* ambari-server/src/test/java/org/apache/ambari/server/view/persistence/DataStoreImplTest.java
* ambari-server/src/main/java/org/apache/ambari/server/orm/entities/ViewInstanceEntity.java


> Views : Data storage error when try to execute some query in hive view
> ----------------------------------------------------------------------
>
>                 Key: AMBARI-11788
>                 URL: https://issues.apache.org/jira/browse/AMBARI-11788
>             Project: Ambari
>          Issue Type: Bug
>            Reporter: Tom Beerbower
>            Assignee: Tom Beerbower
>             Fix For: 2.1.0
>
>
> It looks like the main issue here is that both the SavedQuery and the JobImpl entities have fields named "dataBase". The fields in the entities get mapped to columns when the tables are created. In MySQL (and maybe other dbs) it looks like database is a reserved word and can not be used for a column name.
> We use eclipselink dynamic JPA to generate the tables. Unfortunately, that code tests for a table's existence by issuing the create table statement and catching any Exception. If any exception it thrown (including SQL syntax error) it assumes that the table exists and just continues on without propagating any error.
> The exception that we see is when we try to read from or store to the data store with one of those entities. Since the table doesn't exist, the query fails.
> A fix might be to munge the column names by adding a prefix in the datastore code. There would potentially be a backwards compatability issue, so we would have to introduce a flag to leave existing datastore tables alone.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)