You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2019/06/11 14:49:00 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3577
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3577/display/redirect>
------------------------------------------
[...truncated 278.18 KB...]
|30.571428571428573|2012-01-01 00:00:...|
|30.460251046025103|2007-01-01 00:00:...|
|29.519685039370078|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-11 14:47:25 AUDIT audit:72 - {"time":"June 11, 2019 7:47:25 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19952188230629534","opStatus":"START"}
2019-06-11 14:47:25 AUDIT audit:93 - {"time":"June 11, 2019 7:47:25 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19952188230629534","opStatus":"SUCCESS","opTime":"265 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-11 14:47:25 AUDIT audit:72 - {"time":"June 11, 2019 7:47:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952188585830266","opStatus":"START"}
2019-06-11 14:47:25 AUDIT audit:93 - {"time":"June 11, 2019 7:47:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952188585830266","opStatus":"SUCCESS","opTime":"66 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-11 14:47:25 AUDIT audit:72 - {"time":"June 11, 2019 7:47:25 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"19952188654127127","opStatus":"START"}
2019-06-11 14:47:26 AUDIT audit:93 - {"time":"June 11, 2019 7:47:26 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"19952188654127127","opStatus":"SUCCESS","opTime":"689 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.06KB","IndexSize":"720.0B"}}
2019-06-11 14:47:26 AUDIT audit:72 - {"time":"June 11, 2019 7:47:26 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"19952189352281102","opStatus":"START"}
2019-06-11 14:47:28 AUDIT audit:93 - {"time":"June 11, 2019 7:47:28 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"19952189352281102","opStatus":"SUCCESS","opTime":"1954 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 18|
+--------+
+--------+
|count(1)|
+--------+
| 18|
+--------+
time for query on table with lucene datamap table:0.261
time for query on table without lucene datamap table:0.163
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name1|
|which test1 good7|who and name5|
|which test1 good2|who and name5|
|which test1 good3|who and name2|
|which test1 good4|who and name4|
|which test1 good8|who and name2|
|which test1 good8|who and name4|
|which test1 good0|who and name2|
|which test1 good8|who and name1|
|which test1 good7|who and name5|
|which test1 good2|who and name5|
|which test1 good3|who and name2|
|which test1 good4|who and name4|
|which test1 good8|who and name2|
|which test1 good8|who and name4|
|which test1 good0|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name1|
|which test1 good7|who and name5|
|which test1 good2|who and name5|
|which test1 good1|who and name4|
|which test1 good3|who and name2|
|which test1 good4|who and name4|
|which test1 good8|who and name2|
|which test1 good8|who and name4|
|which test1 good0|who and name2|
|which test1 good8|who and name1|
+-----------------+-------------+
2019-06-11 14:47:29 AUDIT audit:72 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19952192032070711","opStatus":"START"}
2019-06-11 14:47:29 AUDIT audit:93 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19952192032070711","opStatus":"SUCCESS","opTime":"87 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-11 14:47:29 AUDIT audit:72 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952192136315630","opStatus":"START"}
2019-06-11 14:47:29 AUDIT audit:93 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952192136315630","opStatus":"SUCCESS","opTime":"58 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-11 14:47:29 AUDIT audit:72 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192197855807","opStatus":"START"}
2019-06-11 14:47:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-11 14:47:29 AUDIT audit:93 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192197855807","opStatus":"SUCCESS","opTime":"230 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-11 14:47:29 AUDIT audit:72 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192434472864","opStatus":"START"}
2019-06-11 14:47:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-11 14:47:29 AUDIT audit:93 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192434472864","opStatus":"SUCCESS","opTime":"231 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-11 14:47:29 AUDIT audit:72 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192671619743","opStatus":"START"}
2019-06-11 14:47:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-11 14:47:29 AUDIT audit:93 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192671619743","opStatus":"SUCCESS","opTime":"230 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-11 14:47:29 AUDIT audit:72 - {"time":"June 11, 2019 7:47:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192907082062","opStatus":"START"}
2019-06-11 14:47:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-11 14:47:30 AUDIT audit:93 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952192907082062","opStatus":"SUCCESS","opTime":"217 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-11 14:47:30 AUDIT audit:72 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952193172431409","opStatus":"START"}
2019-06-11 14:47:30 AUDIT audit:93 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952193172431409","opStatus":"SUCCESS","opTime":"45 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-11 14:47:30 AUDIT audit:72 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952193270289767","opStatus":"START"}
2019-06-11 14:47:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-11 14:47:30 AUDIT audit:93 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952193270289767","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-11 14:47:30 AUDIT audit:72 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952193446539969","opStatus":"START"}
2019-06-11 14:47:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-11 14:47:30 AUDIT audit:93 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952193446539969","opStatus":"SUCCESS","opTime":"175 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-11 14:47:30 AUDIT audit:72 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19952193667727500","opStatus":"START"}
2019-06-11 14:47:30 AUDIT audit:93 - {"time":"June 11, 2019 7:47:30 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19952193667727500","opStatus":"SUCCESS","opTime":"69 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-11 14:47:31 AUDIT audit:72 - {"time":"June 11, 2019 7:47:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952193981925663","opStatus":"START"}
2019-06-11 14:47:31 AUDIT audit:93 - {"time":"June 11, 2019 7:47:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19952193981925663","opStatus":"SUCCESS","opTime":"79 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-11 14:47:31 AUDIT audit:72 - {"time":"June 11, 2019 7:47:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952194081972833","opStatus":"START"}
2019-06-11 14:47:31 AUDIT audit:93 - {"time":"June 11, 2019 7:47:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952194081972833","opStatus":"SUCCESS","opTime":"230 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-11 14:47:31 AUDIT audit:72 - {"time":"June 11, 2019 7:47:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952194324598259","opStatus":"START"}
2019-06-11 14:47:31 AUDIT audit:93 - {"time":"June 11, 2019 7:47:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19952194324598259","opStatus":"SUCCESS","opTime":"186 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 38 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3581
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3581/display/redirect>
------------------------------------------
[...truncated 277.89 KB...]
|31.197674418604652|2005-01-01 00:00:...|
|32.039568345323744|2014-01-01 00:00:...|
| 29.50210970464135|2016-01-01 00:00:...|
| 29.96747967479675|2011-01-01 00:00:...|
|28.935361216730037|2015-01-01 00:00:...|
|30.572649572649574|2009-01-01 00:00:...|
|29.171102661596958|2002-01-01 00:00:...|
| 27.18421052631579|2004-01-01 00:00:...|
| 30.31764705882353|2000-01-01 00:00:...|
| 30.20940170940171|2008-01-01 00:00:...|
| 29.47641509433962|2012-01-01 00:00:...|
| 29.35215946843854|2007-01-01 00:00:...|
|28.602316602316602|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-12 17:35:05 AUDIT audit:72 - {"time":"June 12, 2019 10:35:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16997140685462938","opStatus":"START"}
2019-06-12 17:35:06 AUDIT audit:93 - {"time":"June 12, 2019 10:35:06 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16997140685462938","opStatus":"SUCCESS","opTime":"501 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-12 17:35:06 AUDIT audit:72 - {"time":"June 12, 2019 10:35:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997141295103273","opStatus":"START"}
2019-06-12 17:35:06 AUDIT audit:93 - {"time":"June 12, 2019 10:35:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997141295103273","opStatus":"SUCCESS","opTime":"223 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 17:35:06 AUDIT audit:72 - {"time":"June 12, 2019 10:35:06 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16997141521811296","opStatus":"START"}
2019-06-12 17:35:07 AUDIT audit:93 - {"time":"June 12, 2019 10:35:07 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16997141521811296","opStatus":"SUCCESS","opTime":"625 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.88KB","IndexSize":"720.0B"}}
2019-06-12 17:35:07 AUDIT audit:72 - {"time":"June 12, 2019 10:35:07 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16997142152545637","opStatus":"START"}
2019-06-12 17:35:09 AUDIT audit:93 - {"time":"June 12, 2019 10:35:09 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16997142152545637","opStatus":"SUCCESS","opTime":"2434 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 8|
+--------+
+--------+
|count(1)|
+--------+
| 8|
+--------+
time for query on table with lucene datamap table:0.225
time for query on table without lucene datamap table:0.147
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name4|
|which test1 good7|who and name7|
|which test1 good8|who and name6|
|which test1 good0|who and name2|
|which test1 good0|who and name4|
|which test1 good7|who and name7|
|which test1 good8|who and name6|
|which test1 good0|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name4|
|which test1 good7|who and name7|
|which test1 good8|who and name6|
|which test1 good0|who and name2|
|which test1 good0|who and name4|
|which test1 good7|who and name7|
|which test1 good8|who and name6|
|which test1 good0|who and name2|
+-----------------+-------------+
2019-06-12 17:35:10 AUDIT audit:72 - {"time":"June 12, 2019 10:35:10 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16997145218472719","opStatus":"START"}
2019-06-12 17:35:10 AUDIT audit:93 - {"time":"June 12, 2019 10:35:10 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16997145218472719","opStatus":"SUCCESS","opTime":"155 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-12 17:35:10 AUDIT audit:72 - {"time":"June 12, 2019 10:35:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997145384723703","opStatus":"START"}
2019-06-12 17:35:10 AUDIT audit:93 - {"time":"June 12, 2019 10:35:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997145384723703","opStatus":"SUCCESS","opTime":"81 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 17:35:10 AUDIT audit:72 - {"time":"June 12, 2019 10:35:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997145469485230","opStatus":"START"}
2019-06-12 17:35:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 17:35:10 AUDIT audit:93 - {"time":"June 12, 2019 10:35:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997145469485230","opStatus":"SUCCESS","opTime":"174 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 17:35:10 AUDIT audit:72 - {"time":"June 12, 2019 10:35:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997145647762927","opStatus":"START"}
2019-06-12 17:35:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 17:35:11 AUDIT audit:93 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997145647762927","opStatus":"SUCCESS","opTime":"209 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 17:35:11 AUDIT audit:72 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997145861461682","opStatus":"START"}
2019-06-12 17:35:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 17:35:11 AUDIT audit:93 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997145861461682","opStatus":"SUCCESS","opTime":"180 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 17:35:11 AUDIT audit:72 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997146047256065","opStatus":"START"}
2019-06-12 17:35:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 17:35:11 AUDIT audit:93 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997146047256065","opStatus":"SUCCESS","opTime":"199 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 17:35:11 AUDIT audit:72 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997146301490427","opStatus":"START"}
2019-06-12 17:35:11 AUDIT audit:93 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997146301490427","opStatus":"SUCCESS","opTime":"87 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 17:35:11 AUDIT audit:72 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997146450487380","opStatus":"START"}
2019-06-12 17:35:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 17:35:11 AUDIT audit:93 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997146450487380","opStatus":"SUCCESS","opTime":"214 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 17:35:11 AUDIT audit:72 - {"time":"June 12, 2019 10:35:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997146671396230","opStatus":"START"}
2019-06-12 17:35:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 17:35:12 AUDIT audit:93 - {"time":"June 12, 2019 10:35:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997146671396230","opStatus":"SUCCESS","opTime":"198 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-12 17:35:12 AUDIT audit:72 - {"time":"June 12, 2019 10:35:12 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16997146949416329","opStatus":"START"}
2019-06-12 17:35:12 AUDIT audit:93 - {"time":"June 12, 2019 10:35:12 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16997146949416329","opStatus":"SUCCESS","opTime":"177 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-12 17:35:12 AUDIT audit:72 - {"time":"June 12, 2019 10:35:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997147436535766","opStatus":"START"}
2019-06-12 17:35:12 AUDIT audit:93 - {"time":"June 12, 2019 10:35:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16997147436535766","opStatus":"SUCCESS","opTime":"211 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 17:35:12 AUDIT audit:72 - {"time":"June 12, 2019 10:35:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997147664721335","opStatus":"START"}
2019-06-12 17:35:13 AUDIT audit:93 - {"time":"June 12, 2019 10:35:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997147664721335","opStatus":"SUCCESS","opTime":"219 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-12 17:35:13 AUDIT audit:72 - {"time":"June 12, 2019 10:35:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997147893302892","opStatus":"START"}
2019-06-12 17:35:13 AUDIT audit:93 - {"time":"June 12, 2019 10:35:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16997147893302892","opStatus":"SUCCESS","opTime":"184 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 3 minutes, 10 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3580
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3580/display/redirect>
------------------------------------------
[...truncated 278.47 KB...]
|29.512915129151292|2011-01-01 00:00:...|
|29.140151515151516|2009-01-01 00:00:...|
|28.416666666666668|2002-01-01 00:00:...|
|30.445833333333333|2004-01-01 00:00:...|
| 30.06694560669456|2000-01-01 00:00:...|
|30.163793103448278|2008-01-01 00:00:...|
|29.099585062240664|2012-01-01 00:00:...|
| 28.98046875|2007-01-01 00:00:...|
| 29.34156378600823|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-12 13:46:04 AUDIT audit:72 - {"time":"June 12, 2019 6:46:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16983399089881461","opStatus":"START"}
2019-06-12 13:46:04 AUDIT audit:93 - {"time":"June 12, 2019 6:46:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16983399089881461","opStatus":"SUCCESS","opTime":"269 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-12 13:46:04 AUDIT audit:72 - {"time":"June 12, 2019 6:46:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983399452138621","opStatus":"START"}
2019-06-12 13:46:04 AUDIT audit:93 - {"time":"June 12, 2019 6:46:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983399452138621","opStatus":"SUCCESS","opTime":"87 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 13:46:04 AUDIT audit:72 - {"time":"June 12, 2019 6:46:04 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16983399542021285","opStatus":"START"}
2019-06-12 13:46:05 AUDIT audit:93 - {"time":"June 12, 2019 6:46:05 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16983399542021285","opStatus":"SUCCESS","opTime":"722 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"772.07KB","IndexSize":"720.0B"}}
2019-06-12 13:46:05 AUDIT audit:72 - {"time":"June 12, 2019 6:46:05 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16983400270291233","opStatus":"START"}
2019-06-12 13:46:07 AUDIT audit:93 - {"time":"June 12, 2019 6:46:07 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16983400270291233","opStatus":"SUCCESS","opTime":"2236 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 12|
+--------+
+--------+
|count(1)|
+--------+
| 12|
+--------+
time for query on table with lucene datamap table:0.277
time for query on table without lucene datamap table:0.207
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name2|
|which test1 good3|who and name6|
|which test1 good8|who and name5|
|which test1 good9|who and name6|
|which test1 good4|who and name6|
|which test1 good6|who and name2|
|which test1 good3|who and name6|
|which test1 good8|who and name5|
|which test1 good9|who and name6|
|which test1 good4|who and name6|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name2|
|which test1 good3|who and name6|
|which test1 good8|who and name5|
|which test1 good1|who and name2|
|which test1 good9|who and name6|
|which test1 good4|who and name6|
|which test1 good6|who and name2|
|which test1 good3|who and name6|
|which test1 good8|who and name5|
|which test1 good1|who and name2|
+-----------------+-------------+
2019-06-12 13:46:08 AUDIT audit:72 - {"time":"June 12, 2019 6:46:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16983403354857768","opStatus":"START"}
2019-06-12 13:46:08 AUDIT audit:93 - {"time":"June 12, 2019 6:46:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16983403354857768","opStatus":"SUCCESS","opTime":"121 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-12 13:46:08 AUDIT audit:72 - {"time":"June 12, 2019 6:46:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983403490760062","opStatus":"START"}
2019-06-12 13:46:08 AUDIT audit:93 - {"time":"June 12, 2019 6:46:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983403490760062","opStatus":"SUCCESS","opTime":"72 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 13:46:08 AUDIT audit:72 - {"time":"June 12, 2019 6:46:08 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983403570000810","opStatus":"START"}
2019-06-12 13:46:08 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 13:46:09 AUDIT audit:93 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983403570000810","opStatus":"SUCCESS","opTime":"217 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 13:46:09 AUDIT audit:72 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983403793540369","opStatus":"START"}
2019-06-12 13:46:09 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 13:46:09 AUDIT audit:93 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983403793540369","opStatus":"SUCCESS","opTime":"198 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 13:46:09 AUDIT audit:72 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983403997924679","opStatus":"START"}
2019-06-12 13:46:09 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 13:46:09 AUDIT audit:93 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983403997924679","opStatus":"SUCCESS","opTime":"221 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 13:46:09 AUDIT audit:72 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983404224684987","opStatus":"START"}
2019-06-12 13:46:09 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 13:46:09 AUDIT audit:93 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983404224684987","opStatus":"SUCCESS","opTime":"222 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 13:46:09 AUDIT audit:72 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983404510613726","opStatus":"START"}
2019-06-12 13:46:09 AUDIT audit:93 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983404510613726","opStatus":"SUCCESS","opTime":"61 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 13:46:09 AUDIT audit:72 - {"time":"June 12, 2019 6:46:09 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983404637856508","opStatus":"START"}
2019-06-12 13:46:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 13:46:10 AUDIT audit:93 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983404637856508","opStatus":"SUCCESS","opTime":"204 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 13:46:10 AUDIT audit:72 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983404847099477","opStatus":"START"}
2019-06-12 13:46:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 13:46:10 AUDIT audit:93 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983404847099477","opStatus":"SUCCESS","opTime":"184 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-12 13:46:10 AUDIT audit:72 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16983405087645206","opStatus":"START"}
2019-06-12 13:46:10 AUDIT audit:93 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16983405087645206","opStatus":"SUCCESS","opTime":"104 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-12 13:46:10 AUDIT audit:72 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983405486852345","opStatus":"START"}
2019-06-12 13:46:10 AUDIT audit:93 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16983405486852345","opStatus":"SUCCESS","opTime":"76 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 13:46:10 AUDIT audit:72 - {"time":"June 12, 2019 6:46:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983405584162739","opStatus":"START"}
2019-06-12 13:46:11 AUDIT audit:93 - {"time":"June 12, 2019 6:46:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983405584162739","opStatus":"SUCCESS","opTime":"211 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-12 13:46:11 AUDIT audit:72 - {"time":"June 12, 2019 6:46:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983405804693949","opStatus":"START"}
2019-06-12 13:46:11 AUDIT audit:93 - {"time":"June 12, 2019 6:46:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16983405804693949","opStatus":"SUCCESS","opTime":"240 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 40 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3579
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3579/display/redirect>
------------------------------------------
[...truncated 292.77 KB...]
| 30.16317991631799|2005-01-01 00:00:...|
|29.970338983050848|2014-01-01 00:00:...|
|29.804979253112034|2016-01-01 00:00:...|
|29.211764705882352|2015-01-01 00:00:...|
|28.934362934362934|2011-01-01 00:00:...|
|28.738396624472575|2009-01-01 00:00:...|
|26.260223048327138|2002-01-01 00:00:...|
| 28.71900826446281|2004-01-01 00:00:...|
|29.584313725490198|2000-01-01 00:00:...|
| 28.316|2008-01-01 00:00:...|
|29.518115942028984|2012-01-01 00:00:...|
| 29.42168674698795|2007-01-01 00:00:...|
|30.486166007905137|2013-01-01 00:00:...|
| 29.45019920318725|2001-01-01 00:00:...|
+------------------+--------------------+
2019-06-12 09:55:41 AUDIT audit:72 - {"time":"June 12, 2019 2:55:41 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110294965044817","opStatus":"START"}
2019-06-12 09:55:42 AUDIT audit:93 - {"time":"June 12, 2019 2:55:42 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110294965044817","opStatus":"SUCCESS","opTime":"344 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-12 09:55:42 AUDIT audit:72 - {"time":"June 12, 2019 2:55:42 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110295383335445","opStatus":"START"}
2019-06-12 09:55:42 AUDIT audit:93 - {"time":"June 12, 2019 2:55:42 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110295383335445","opStatus":"SUCCESS","opTime":"93 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 09:55:42 AUDIT audit:72 - {"time":"June 12, 2019 2:55:42 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5110295479814378","opStatus":"START"}
2019-06-12 09:55:43 AUDIT audit:93 - {"time":"June 12, 2019 2:55:43 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5110295479814378","opStatus":"SUCCESS","opTime":"832 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.92KB","IndexSize":"720.0B"}}
2019-06-12 09:55:43 AUDIT audit:72 - {"time":"June 12, 2019 2:55:43 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5110296319693410","opStatus":"START"}
2019-06-12 09:55:45 AUDIT audit:93 - {"time":"June 12, 2019 2:55:45 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5110296319693410","opStatus":"SUCCESS","opTime":"2532 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 10|
+--------+
+--------+
|count(1)|
+--------+
| 10|
+--------+
time for query on table with lucene datamap table:0.267
time for query on table without lucene datamap table:0.201
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name6|
|which test1 good7|who and name5|
|which test1 good0|who and name6|
|which test1 good0|who and name6|
|which test1 good7|who and name5|
|which test1 good0|who and name6|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good1|who and name3|
|which test1 good0|who and name6|
|which test1 good1|who and name0|
|which test1 good7|who and name5|
|which test1 good0|who and name6|
|which test1 good1|who and name3|
|which test1 good0|who and name6|
|which test1 good1|who and name0|
|which test1 good7|who and name5|
|which test1 good0|who and name6|
+-----------------+-------------+
2019-06-12 09:55:46 AUDIT audit:72 - {"time":"June 12, 2019 2:55:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110299696998998","opStatus":"START"}
2019-06-12 09:55:46 AUDIT audit:93 - {"time":"June 12, 2019 2:55:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110299696998998","opStatus":"SUCCESS","opTime":"148 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-12 09:55:46 AUDIT audit:72 - {"time":"June 12, 2019 2:55:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110299866833184","opStatus":"START"}
2019-06-12 09:55:46 AUDIT audit:93 - {"time":"June 12, 2019 2:55:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110299866833184","opStatus":"SUCCESS","opTime":"77 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 09:55:46 AUDIT audit:72 - {"time":"June 12, 2019 2:55:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110299949906706","opStatus":"START"}
2019-06-12 09:55:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:55:47 AUDIT audit:93 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110299949906706","opStatus":"SUCCESS","opTime":"206 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:55:47 AUDIT audit:72 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110300161357633","opStatus":"START"}
2019-06-12 09:55:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:55:47 AUDIT audit:93 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110300161357633","opStatus":"SUCCESS","opTime":"189 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:55:47 AUDIT audit:72 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110300356908849","opStatus":"START"}
2019-06-12 09:55:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:55:47 AUDIT audit:93 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110300356908849","opStatus":"SUCCESS","opTime":"211 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:55:47 AUDIT audit:72 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110300575062100","opStatus":"START"}
2019-06-12 09:55:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:55:47 AUDIT audit:93 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110300575062100","opStatus":"SUCCESS","opTime":"213 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 09:55:47 AUDIT audit:72 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110300864465583","opStatus":"START"}
2019-06-12 09:55:47 AUDIT audit:93 - {"time":"June 12, 2019 2:55:47 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110300864465583","opStatus":"SUCCESS","opTime":"149 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 09:55:48 AUDIT audit:72 - {"time":"June 12, 2019 2:55:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110301102649475","opStatus":"START"}
2019-06-12 09:55:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:55:48 AUDIT audit:93 - {"time":"June 12, 2019 2:55:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110301102649475","opStatus":"SUCCESS","opTime":"204 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:55:48 AUDIT audit:72 - {"time":"June 12, 2019 2:55:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110301312832964","opStatus":"START"}
2019-06-12 09:55:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:55:48 AUDIT audit:93 - {"time":"June 12, 2019 2:55:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110301312832964","opStatus":"SUCCESS","opTime":"223 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-12 09:55:48 AUDIT audit:72 - {"time":"June 12, 2019 2:55:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110301603528181","opStatus":"START"}
2019-06-12 09:55:48 AUDIT audit:93 - {"time":"June 12, 2019 2:55:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110301603528181","opStatus":"SUCCESS","opTime":"142 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-12 09:55:48 AUDIT audit:72 - {"time":"June 12, 2019 2:55:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110302033934112","opStatus":"START"}
2019-06-12 09:55:49 AUDIT audit:93 - {"time":"June 12, 2019 2:55:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110302033934112","opStatus":"SUCCESS","opTime":"94 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 09:55:49 AUDIT audit:72 - {"time":"June 12, 2019 2:55:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110302154948701","opStatus":"START"}
2019-06-12 09:55:49 AUDIT audit:93 - {"time":"June 12, 2019 2:55:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110302154948701","opStatus":"SUCCESS","opTime":"204 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-12 09:55:49 AUDIT audit:72 - {"time":"June 12, 2019 2:55:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110302370237032","opStatus":"START"}
2019-06-12 09:55:49 AUDIT audit:93 - {"time":"June 12, 2019 2:55:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110302370237032","opStatus":"SUCCESS","opTime":"210 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 3 minutes, 8 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3578
Posted by Apache Jenkins Server <je...@builds.apache.org>.
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3578/display/redirect>
------------------------------------------
[...truncated 277.77 KB...]
|28.591836734693878|2002-01-01 00:00:...|
|28.972332015810277|2004-01-01 00:00:...|
| 28.66793893129771|2000-01-01 00:00:...|
| 29.18045112781955|2008-01-01 00:00:...|
|27.282945736434108|2012-01-01 00:00:...|
|30.786008230452676|2007-01-01 00:00:...|
|29.903703703703705|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-12 09:54:05 AUDIT audit:72 - {"time":"June 12, 2019 2:54:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110198263472839","opStatus":"START"}
2019-06-12 09:54:05 AUDIT audit:93 - {"time":"June 12, 2019 2:54:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110198263472839","opStatus":"SUCCESS","opTime":"368 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-12 09:54:05 AUDIT audit:72 - {"time":"June 12, 2019 2:54:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110198800673455","opStatus":"START"}
2019-06-12 09:54:05 AUDIT audit:93 - {"time":"June 12, 2019 2:54:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110198800673455","opStatus":"SUCCESS","opTime":"76 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 09:54:05 AUDIT audit:72 - {"time":"June 12, 2019 2:54:05 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5110198879107690","opStatus":"START"}
2019-06-12 09:54:06 AUDIT audit:93 - {"time":"June 12, 2019 2:54:06 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5110198879107690","opStatus":"SUCCESS","opTime":"791 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.72KB","IndexSize":"720.0B"}}
2019-06-12 09:54:06 AUDIT audit:72 - {"time":"June 12, 2019 2:54:06 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5110199682403587","opStatus":"START"}
2019-06-12 09:54:08 AUDIT audit:93 - {"time":"June 12, 2019 2:54:08 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5110199682403587","opStatus":"SUCCESS","opTime":"2216 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 14|
+--------+
+--------+
|count(1)|
+--------+
| 14|
+--------+
time for query on table with lucene datamap table:0.304
time for query on table without lucene datamap table:0.23
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name3|
|which test1 good6|who and name4|
|which test1 good9|who and name4|
|which test1 good2|who and name4|
|which test1 good4|who and name4|
|which test1 good5|who and name6|
|which test1 good2|who and name3|
|which test1 good6|who and name4|
|which test1 good9|who and name4|
|which test1 good2|who and name4|
|which test1 good4|who and name4|
|which test1 good5|who and name6|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good1|who and name0|
|which test1 good2|who and name3|
|which test1 good6|who and name4|
|which test1 good9|who and name4|
|which test1 good2|who and name4|
|which test1 good4|who and name4|
|which test1 good5|who and name6|
|which test1 good1|who and name0|
|which test1 good2|who and name3|
|which test1 good6|who and name4|
+-----------------+-------------+
2019-06-12 09:54:09 AUDIT audit:72 - {"time":"June 12, 2019 2:54:09 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110202841162555","opStatus":"START"}
2019-06-12 09:54:09 AUDIT audit:93 - {"time":"June 12, 2019 2:54:09 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110202841162555","opStatus":"SUCCESS","opTime":"177 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-12 09:54:09 AUDIT audit:72 - {"time":"June 12, 2019 2:54:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110203038661315","opStatus":"START"}
2019-06-12 09:54:10 AUDIT audit:93 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110203038661315","opStatus":"SUCCESS","opTime":"95 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 09:54:10 AUDIT audit:72 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203139957059","opStatus":"START"}
2019-06-12 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:54:10 AUDIT audit:93 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203139957059","opStatus":"SUCCESS","opTime":"205 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:54:10 AUDIT audit:72 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203350766578","opStatus":"START"}
2019-06-12 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:54:10 AUDIT audit:93 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203350766578","opStatus":"SUCCESS","opTime":"186 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:54:10 AUDIT audit:72 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203541590247","opStatus":"START"}
2019-06-12 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:54:10 AUDIT audit:93 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203541590247","opStatus":"SUCCESS","opTime":"191 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:54:10 AUDIT audit:72 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203738128885","opStatus":"START"}
2019-06-12 09:54:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:54:10 AUDIT audit:93 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110203738128885","opStatus":"SUCCESS","opTime":"184 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 09:54:10 AUDIT audit:72 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110203993143422","opStatus":"START"}
2019-06-12 09:54:10 AUDIT audit:93 - {"time":"June 12, 2019 2:54:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110203993143422","opStatus":"SUCCESS","opTime":"75 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-12 09:54:11 AUDIT audit:72 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110204138487668","opStatus":"START"}
2019-06-12 09:54:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:54:11 AUDIT audit:93 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110204138487668","opStatus":"SUCCESS","opTime":"200 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-12 09:54:11 AUDIT audit:72 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110204344688764","opStatus":"START"}
2019-06-12 09:54:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-12 09:54:11 AUDIT audit:93 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110204344688764","opStatus":"SUCCESS","opTime":"182 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-12 09:54:11 AUDIT audit:72 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110204585154617","opStatus":"START"}
2019-06-12 09:54:11 AUDIT audit:93 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5110204585154617","opStatus":"SUCCESS","opTime":"104 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-12 09:54:11 AUDIT audit:72 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110204965145590","opStatus":"START"}
2019-06-12 09:54:11 AUDIT audit:93 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5110204965145590","opStatus":"SUCCESS","opTime":"94 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-12 09:54:11 AUDIT audit:72 - {"time":"June 12, 2019 2:54:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110205080132016","opStatus":"START"}
2019-06-12 09:54:12 AUDIT audit:93 - {"time":"June 12, 2019 2:54:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110205080132016","opStatus":"SUCCESS","opTime":"183 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-12 09:54:12 AUDIT audit:72 - {"time":"June 12, 2019 2:54:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110205274575349","opStatus":"START"}
2019-06-12 09:54:12 AUDIT audit:93 - {"time":"June 12, 2019 2:54:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5110205274575349","opStatus":"SUCCESS","opTime":"190 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 3 minutes, 10 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results