[ https://issues.apache.org/jira/browse/HIVE-13290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15213474#comment-15213474 ]
Hive QA commented on HIVE-13290: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12795175/HIVE-13290.2.patch {color:red}ERROR:{color} -1 due to build exiting with an error Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7384/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/7384/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-7384/ Messages: {noformat} **** This message was trimmed, see log for full details **** symbol: class ForeignKeyRel location: class org.apache.hadoop.hive.metastore.ObjectStore [INFO] 45 errors [INFO] ------------------------------------------------------------- [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] Hive .............................................. SUCCESS [13.137s] [INFO] Hive Shims Common ................................. SUCCESS [16.966s] [INFO] Hive Shims 0.23 ................................... SUCCESS [13.640s] [INFO] Hive Shims Scheduler .............................. SUCCESS [2.842s] [INFO] Hive Shims ........................................ SUCCESS [2.619s] [INFO] Hive Storage API .................................. SUCCESS [7.776s] [INFO] Hive ORC .......................................... SUCCESS [12.054s] [INFO] Hive Common ....................................... SUCCESS [23.996s] [INFO] Hive Serde ........................................ SUCCESS [15.958s] [INFO] Hive Metastore .................................... FAILURE [32.478s] [INFO] Hive Ant Utilities ................................ SKIPPED [INFO] Hive Llap Common .................................. SKIPPED [INFO] Hive Llap Client .................................. SKIPPED [INFO] Hive Llap Tez ..................................... SKIPPED [INFO] Hive Service RPC .................................. SKIPPED [INFO] Spark Remote Client ............................... SKIPPED [INFO] Hive Query Language ............................... SKIPPED [INFO] Hive Service ...................................... SKIPPED [INFO] Hive Accumulo Handler ............................. SKIPPED [INFO] Hive JDBC ......................................... SKIPPED [INFO] Hive Beeline ...................................... SKIPPED [INFO] Hive CLI .......................................... SKIPPED [INFO] Hive Contrib ...................................... SKIPPED [INFO] Hive HBase Handler ................................ SKIPPED [INFO] Hive HCatalog ..................................... SKIPPED [INFO] Hive HCatalog Core ................................ SKIPPED [INFO] Hive HCatalog Pig Adapter ......................... SKIPPED [INFO] Hive HCatalog Server Extensions ................... SKIPPED [INFO] Hive HCatalog Webhcat Java Client ................. SKIPPED [INFO] Hive HCatalog Webhcat ............................. SKIPPED [INFO] Hive HCatalog Streaming ........................... SKIPPED [INFO] Hive HPL/SQL ...................................... SKIPPED [INFO] Hive HWI .......................................... SKIPPED [INFO] Hive Llap Server .................................. SKIPPED [INFO] Hive Shims Aggregator ............................. SKIPPED [INFO] Hive TestUtils .................................... SKIPPED [INFO] Hive Packaging .................................... SKIPPED [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 2:24.890s [INFO] Finished at: Sun Mar 27 09:56:15 EDT 2016 [INFO] Final Memory: 76M/745M [INFO] ------------------------------------------------------------------------ [WARNING] The requested profile "hadoop-2" could not be activated because it does not exist. [ERROR] Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1:compile (default-compile) on project hive-metastore: Compilation failure: Compilation failure: [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[79,16] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[254,10] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[750,29] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[754,32] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[761,15] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[765,35] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/model/org/apache/hadoop/hive/metastore/model/MTable.java:[24,44] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: package org.apache.hadoop.hive.metastore.api [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[75,44] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: package org.apache.hadoop.hive.metastore.api [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java:[52,44] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: package org.apache.hadoop.hive.metastore.api [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1346,62] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1360,16] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[3246,10] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[79,16] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[254,10] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[750,29] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[754,32] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[761,15] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[765,35] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/model/org/apache/hadoop/hive/metastore/model/MTable.java:[24,44] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: package org.apache.hadoop.hive.metastore.api [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[75,44] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: package org.apache.hadoop.hive.metastore.api [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java:[52,44] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: package org.apache.hadoop.hive.metastore.api [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1346,62] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1360,16] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[3246,10] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[230,101] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[328,12] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[328,63] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[329,12] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[330,37] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[756,40] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[910,30] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[1775,52] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableStandardScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[1776,17] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableStandardScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[1779,34] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableStandardScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[1900,16] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableStandardScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[2042,16] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableTupleScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[2150,46] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableTupleScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[2151,11] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableTupleScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Table.java:[2154,28] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.api.Table.TableTupleScheme [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[912,12] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1349,10] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1365,12] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1365,50] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1368,9] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] /data/hive-ptest/working/apache-github-source-source/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java:[1370,22] cannot find symbol [ERROR] symbol: class ForeignKeyRel [ERROR] location: class org.apache.hadoop.hive.metastore.ObjectStore [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException [ERROR] [ERROR] After correcting the problems, you can resume the build with the command [ERROR] mvn <goals> -rf :hive-metastore + exit 1 ' {noformat} This message is automatically generated. ATTACHMENT ID: 12795175 - PreCommit-HIVE-TRUNK-Build > Support primary keys/foreign keys constraint as part of create table command > in Hive > ------------------------------------------------------------------------------------ > > Key: HIVE-13290 > URL: https://issues.apache.org/jira/browse/HIVE-13290 > Project: Hive > Issue Type: Sub-task > Components: CBO, Logical Optimizer > Reporter: Hari Sankar Sivarama Subramaniyan > Assignee: Hari Sankar Sivarama Subramaniyan > Attachments: HIVE-13290.1.patch, HIVE-13290.2.patch > > > SUPPORT for the following statements > {code} > CREATE TABLE product > ( > product_id INTEGER, > product_vendor_id INTEGER, > PRIMARY KEY (product_id), > CONSTRAINT product_fk_1 FOREIGN KEY (product_vendor_id) REFERENCES > vendor(vendor_id) > ); > CREATE TABLE vendor > ( > vendor_id INTEGER, > PRIMARY KEY (vendor_id) > ); > {code} > In the above syntax, [CONSTRAINT constraint-Name] is optional. If this is not > specified by the user, we will use system generated constraint name. For the > purpose of simplicity, we will allow CONSTRAINT option for foreign keys and > not primary key since there is only one primary key per table. -- This message was sent by Atlassian JIRA (v6.3.4#6332)