ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-11788) Views : Data storage error when try to execute some query in hive view
Date Mon, 08 Jun 2015 19:56:00 GMT

    [ 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)

Mime
View raw message