wangyum commented on issue #25690: [SPARK-27831][FOLLOW-UP][SQL][TEST][test-hadoop3.2][test-maven] Move Hive test jars to local file URL: https://github.com/apache/spark/pull/25690#issuecomment-529990645 It will fail because we _fixed invalid tests in CliSuite_ by [SPARK-28988](https://issues.apache.org/jira/browse/SPARK-28988): ``` - Commands using SerDe provided in --jars *** FAILED *** ======================= CliSuite failure output ======================= Spark SQL CLI command line: ../../bin/spark-sql --master local --driver-java-options -Dderby.system.durability=test --conf spark.ui.enabled=false --hiveconf javax.jdo.option.ConnectionURL=jdbc:derby:;databaseName=/home/jenkins/workspace/SparkPullRequestBuilder/sql/hive-thriftserver/target/tmp/spark-9d7c84e5-cce1-4233-9536-e74a549d1c14;create=true --hiveconf hive.metastore.warehouse.dir=/home/jenkins/workspace/SparkPullRequestBuilder/sql/hive-thriftserver/target/tmp/spark-df1ff8ee-6a2f-4778-9b54-ce19cb0e29f2 --hiveconf hive.exec.scratchdir=/home/jenkins/workspace/SparkPullRequestBuilder/sql/hive-thriftserver/target/tmp/spark-a2ca0517-d088-4af7-a853-62d2353bcf2d --hiveconf conf1=conftest --hiveconf conf2=1 --jars /tmp/test-spark/hiveTestJars/hive-hcatalog-core-2.3.6.jar Exception: java.util.concurrent.TimeoutException: Futures timed out after [3 minutes] Executed query 4 "SELECT collect_list(array(val)) FROM t1;", But failed to capture expected output "[["val_238"],["val_86"],["val_311"],["val_27"],["val_165"]]" within 3 minutes. 2019-09-10 05:13:09.025 - stderr> SLF4J: Class path contains multiple SLF4J bindings. 2019-09-10 05:13:09.025 - stderr> SLF4J: Found binding in [jar:file:/home/jenkins/workspace/SparkPullRequestBuilder/assembly/target/scala-2.12/jars/slf4j-log4j12-1.7.16.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2019-09-10 05:13:09.025 - stderr> SLF4J: Found binding in [jar:file:/home/jenkins/.m2/repository/org/slf4j/slf4j-log4j12/1.7.16/slf4j-log4j12-1.7.16.jar!/org/slf4j/impl/StaticLoggerBinder.class] 2019-09-10 05:13:09.025 - stderr> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 2019-09-10 05:13:09.025 - stderr> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 2019-09-10 05:13:19.653 - stderr> Spark master: local, Application Id: local-1568117591367 2019-09-10 05:13:19.676 - stdout> spark-sql> CREATE TABLE t1(key string, val string) 2019-09-10 05:13:19.689 - stdout> > ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'; 2019-09-10 05:13:22.221 - stderr> Error in query: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: MetaException(message:java.lang.ClassNotFoundException Class org.apache.hive.hcatalog.data.JsonSerDe not found); 2019-09-10 05:13:22.231 - stdout> spark-sql> 2019-09-10 05:13:22.237 - stdout> > CREATE TABLE sourceTable (key INT, val STRING); 2019-09-10 05:13:22.806 - stderr> Time taken: 0.567 seconds 2019-09-10 05:13:22.823 - stdout> spark-sql> LOAD DATA LOCAL INPATH 'file:/home/jenkins/workspace/SparkPullRequestBuilder/sql/hive-thriftserver/target/scala-2.12/test-classes/data/files/small_kv.txt' OVERWRITE INTO TABLE sourceTable; 2019-09-10 05:13:23.467 - stderr> Time taken: 0.642 seconds 2019-09-10 05:13:23.491 - stdout> spark-sql> INSERT INTO TABLE t1 SELECT key, val FROM sourceTable; 2019-09-10 05:13:23.702 - stderr> Error in query: Table not found: t1;; 2019-09-10 05:13:23.702 - stderr> 'InsertIntoTable 'UnresolvedRelation [t1], false, false 2019-09-10 05:13:23.702 - stderr> +- Project [key#0, val#1] 2019-09-10 05:13:23.702 - stderr> +- SubqueryAlias `default`.`sourcetable` 2019-09-10 05:13:23.702 - stderr> +- HiveTableRelation `default`.`sourcetable`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [key#0, val#1] 2019-09-10 05:13:23.702 - stderr> 2019-09-10 05:13:23.708 - stdout> spark-sql> SELECT collect_list(array(val)) FROM t1; 2019-09-10 05:13:23.78 - stderr> Error in query: Table or view not found: t1; line 1 pos 37; 2019-09-10 05:13:23.78 - stderr> 'Project [unresolvedalias('collect_list('array('val)), None)] 2019-09-10 05:13:23.78 - stderr> +- 'UnresolvedRelation [t1] 2019-09-10 05:13:23.78 - stderr> 2019-09-10 05:13:23.785 - stdout> spark-sql> DROP TABLE t1; 2019-09-10 05:13:23.811 - stderr> Error in query: Table or view not found: t1; 2019-09-10 05:13:23.816 - stdout> spark-sql> DROP TABLE sourceTable; 2019-09-10 05:13:24.65 - stderr> Time taken: 0.833 seconds 2019-09-10 05:13:24.832 - stdout> spark-sql> ``` We need to resolve [SPARK-28840](https://issues.apache.org/jira/browse/SPARK-28840) first.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
