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/06 09:56:33 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3570
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3570/display/redirect>
------------------------------------------
[...truncated 277.02 KB...]
|28.438247011952193|2015-01-01 00:00:...|
|28.693486590038315|2009-01-01 00:00:...|
|28.682926829268293|2002-01-01 00:00:...|
| 29.824|2004-01-01 00:00:...|
| 31.45528455284553|2000-01-01 00:00:...|
|29.115384615384617|2008-01-01 00:00:...|
|30.653225806451612|2012-01-01 00:00:...|
|28.109704641350213|2007-01-01 00:00:...|
|30.267489711934157|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-06 09:55:11 AUDIT audit:72 - {"time":"June 6, 2019 2:55:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4591864158482353","opStatus":"START"}
2019-06-06 09:55:11 AUDIT audit:93 - {"time":"June 6, 2019 2:55:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4591864158482353","opStatus":"SUCCESS","opTime":"312 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-06 09:55:11 AUDIT audit:72 - {"time":"June 6, 2019 2:55:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591864647637986","opStatus":"START"}
2019-06-06 09:55:11 AUDIT audit:93 - {"time":"June 6, 2019 2:55:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591864647637986","opStatus":"SUCCESS","opTime":"116 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-06 09:55:11 AUDIT audit:72 - {"time":"June 6, 2019 2:55:11 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"4591864766602433","opStatus":"START"}
2019-06-06 09:55:12 AUDIT audit:93 - {"time":"June 6, 2019 2:55:12 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"4591864766602433","opStatus":"SUCCESS","opTime":"938 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.70KB","IndexSize":"720.0B"}}
2019-06-06 09:55:12 AUDIT audit:72 - {"time":"June 6, 2019 2:55:12 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"4591865713045243","opStatus":"START"}
2019-06-06 09:55:15 AUDIT audit:93 - {"time":"June 6, 2019 2:55:15 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"4591865713045243","opStatus":"SUCCESS","opTime":"2440 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.297
time for query on table without lucene datamap table:0.252
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name0|
|which test1 good9|who and name1|
|which test1 good6|who and name1|
|which test1 good4|who and name1|
|which test1 good2|who and name2|
|which test1 good4|who and name0|
|which test1 good9|who and name1|
|which test1 good6|who and name1|
|which test1 good4|who and name1|
|which test1 good2|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name0|
|which test1 good9|who and name1|
|which test1 good6|who and name1|
|which test1 good4|who and name1|
|which test1 good2|who and name2|
|which test1 good4|who and name0|
|which test1 good9|who and name1|
|which test1 good6|who and name1|
|which test1 good4|who and name1|
|which test1 good2|who and name2|
+-----------------+-------------+
2019-06-06 09:55:16 AUDIT audit:72 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4591869169447750","opStatus":"START"}
2019-06-06 09:55:16 AUDIT audit:93 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4591869169447750","opStatus":"SUCCESS","opTime":"114 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-06 09:55:16 AUDIT audit:72 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591869298029515","opStatus":"START"}
2019-06-06 09:55:16 AUDIT audit:93 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591869298029515","opStatus":"SUCCESS","opTime":"79 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-06 09:55:16 AUDIT audit:72 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591869383387983","opStatus":"START"}
2019-06-06 09:55:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-06 09:55:16 AUDIT audit:93 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591869383387983","opStatus":"SUCCESS","opTime":"213 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-06 09:55:16 AUDIT audit:72 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591869603492546","opStatus":"START"}
2019-06-06 09:55:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-06 09:55:16 AUDIT audit:93 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591869603492546","opStatus":"SUCCESS","opTime":"213 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-06 09:55:16 AUDIT audit:72 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591869822653798","opStatus":"START"}
2019-06-06 09:55:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-06 09:55:16 AUDIT audit:93 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591869822653798","opStatus":"SUCCESS","opTime":"208 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-06 09:55:16 AUDIT audit:72 - {"time":"June 6, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591870037554779","opStatus":"START"}
2019-06-06 09:55:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-06 09:55:17 AUDIT audit:93 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591870037554779","opStatus":"SUCCESS","opTime":"178 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-06 09:55:17 AUDIT audit:72 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591870277816976","opStatus":"START"}
2019-06-06 09:55:17 AUDIT audit:93 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591870277816976","opStatus":"SUCCESS","opTime":"67 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-06 09:55:17 AUDIT audit:72 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591870437015696","opStatus":"START"}
2019-06-06 09:55:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-06 09:55:17 AUDIT audit:93 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591870437015696","opStatus":"SUCCESS","opTime":"203 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-06 09:55:17 AUDIT audit:72 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591870645171519","opStatus":"START"}
2019-06-06 09:55:17 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-06 09:55:17 AUDIT audit:93 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591870645171519","opStatus":"SUCCESS","opTime":"201 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-06 09:55:17 AUDIT audit:72 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4591870927254486","opStatus":"START"}
2019-06-06 09:55:17 AUDIT audit:93 - {"time":"June 6, 2019 2:55:17 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4591870927254486","opStatus":"SUCCESS","opTime":"117 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-06 09:55:18 AUDIT audit:72 - {"time":"June 6, 2019 2:55:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591871365384515","opStatus":"START"}
2019-06-06 09:55:18 AUDIT audit:93 - {"time":"June 6, 2019 2:55:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4591871365384515","opStatus":"SUCCESS","opTime":"95 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-06 09:55:18 AUDIT audit:72 - {"time":"June 6, 2019 2:55:18 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591871490095292","opStatus":"START"}
2019-06-06 09:55:18 AUDIT audit:93 - {"time":"June 6, 2019 2:55:18 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591871490095292","opStatus":"SUCCESS","opTime":"236 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-06 09:55:18 AUDIT audit:72 - {"time":"June 6, 2019 2:55:18 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591871739189552","opStatus":"START"}
2019-06-06 09:55:18 AUDIT audit:93 - {"time":"June 6, 2019 2:55:18 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4591871739189552","opStatus":"SUCCESS","opTime":"182 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, 1 second.[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 #3573
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/3573/display/redirect>
------------------------------------------
[...truncated 277.11 KB...]
+------------------+--------------------+
| 28.91235059760956|2019-01-01 00:00:...|
|30.677824267782427|2006-01-01 00:00:...|
|27.392857142857142|2010-01-01 00:00:...|
| 30.5| null|
|29.384615384615383|2018-01-01 00:00:...|
| 29.48068669527897|2017-01-01 00:00:...|
| 29.9|2003-01-01 00:00:...|
|29.817021276595746|2005-01-01 00:00:...|
|28.804081632653062|2014-01-01 00:00:...|
|29.929961089494164|2016-01-01 00:00:...|
|29.650862068965516|2015-01-01 00:00:...|
|29.995744680851065|2011-01-01 00:00:...|
| 29.304|2009-01-01 00:00:...|
|27.865168539325843|2002-01-01 00:00:...|
| 30.17509727626459|2004-01-01 00:00:...|
|30.984313725490196|2000-01-01 00:00:...|
| 30.16296296296296|2008-01-01 00:00:...|
| 29.11934156378601|2012-01-01 00:00:...|
|28.467432950191572|2007-01-01 00:00:...|
|29.415254237288135|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-09 09:58:23 AUDIT audit:72 - {"time":"June 9, 2019 2:58:23 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4851257016739153","opStatus":"START"}
2019-06-09 09:58:25 AUDIT audit:93 - {"time":"June 9, 2019 2:58:25 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4851257016739153","opStatus":"SUCCESS","opTime":"1359 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-09 09:58:25 AUDIT audit:72 - {"time":"June 9, 2019 2:58:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851258524170648","opStatus":"START"}
2019-06-09 09:58:25 AUDIT audit:93 - {"time":"June 9, 2019 2:58:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851258524170648","opStatus":"SUCCESS","opTime":"91 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-09 09:58:25 AUDIT audit:72 - {"time":"June 9, 2019 2:58:25 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"4851258617976962","opStatus":"START"}
2019-06-09 09:58:26 AUDIT audit:93 - {"time":"June 9, 2019 2:58:26 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"4851258617976962","opStatus":"SUCCESS","opTime":"918 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.27KB","IndexSize":"720.0B"}}
2019-06-09 09:58:26 AUDIT audit:72 - {"time":"June 9, 2019 2:58:26 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"4851259548138414","opStatus":"START"}
2019-06-09 09:58:29 AUDIT audit:93 - {"time":"June 9, 2019 2:58:29 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"4851259548138414","opStatus":"SUCCESS","opTime":"2702 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 4|
+--------+
+--------+
|count(1)|
+--------+
| 4|
+--------+
time for query on table with lucene datamap table:0.285
time for query on table without lucene datamap table:0.231
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name5|
|which test1 good2|who and name6|
|which test1 good4|who and name5|
|which test1 good2|who and name6|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name5|
|which test1 good2|who and name6|
|which test1 good4|who and name5|
|which test1 good2|who and name6|
+-----------------+-------------+
2019-06-09 09:58:30 AUDIT audit:72 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4851263150942518","opStatus":"START"}
2019-06-09 09:58:30 AUDIT audit:93 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4851263150942518","opStatus":"SUCCESS","opTime":"146 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-09 09:58:30 AUDIT audit:72 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851263315722885","opStatus":"START"}
2019-06-09 09:58:30 AUDIT audit:93 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851263315722885","opStatus":"SUCCESS","opTime":"73 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-09 09:58:30 AUDIT audit:72 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851263395343264","opStatus":"START"}
2019-06-09 09:58:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-09 09:58:30 AUDIT audit:93 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851263395343264","opStatus":"SUCCESS","opTime":"209 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-09 09:58:30 AUDIT audit:72 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851263611863297","opStatus":"START"}
2019-06-09 09:58:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-09 09:58:30 AUDIT audit:93 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851263611863297","opStatus":"SUCCESS","opTime":"205 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-09 09:58:30 AUDIT audit:72 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851263822715985","opStatus":"START"}
2019-06-09 09:58:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-09 09:58:30 AUDIT audit:93 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851263822715985","opStatus":"SUCCESS","opTime":"190 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-09 09:58:30 AUDIT audit:72 - {"time":"June 9, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851264017602787","opStatus":"START"}
2019-06-09 09:58:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-09 09:58:31 AUDIT audit:93 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851264017602787","opStatus":"SUCCESS","opTime":"182 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-09 09:58:31 AUDIT audit:72 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851264271427531","opStatus":"START"}
2019-06-09 09:58:31 AUDIT audit:93 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851264271427531","opStatus":"SUCCESS","opTime":"68 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-09 09:58:31 AUDIT audit:72 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851264413158262","opStatus":"START"}
2019-06-09 09:58:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-09 09:58:31 AUDIT audit:93 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851264413158262","opStatus":"SUCCESS","opTime":"174 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-09 09:58:31 AUDIT audit:72 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851264592910810","opStatus":"START"}
2019-06-09 09:58:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-09 09:58:31 AUDIT audit:93 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851264592910810","opStatus":"SUCCESS","opTime":"229 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-09 09:58:31 AUDIT audit:72 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4851264895045031","opStatus":"START"}
2019-06-09 09:58:31 AUDIT audit:93 - {"time":"June 9, 2019 2:58:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"4851264895045031","opStatus":"SUCCESS","opTime":"111 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-09 09:58:32 AUDIT audit:72 - {"time":"June 9, 2019 2:58:32 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851265317322159","opStatus":"START"}
2019-06-09 09:58:32 AUDIT audit:93 - {"time":"June 9, 2019 2:58:32 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"4851265317322159","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-09 09:58:32 AUDIT audit:72 - {"time":"June 9, 2019 2:58:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851265423579754","opStatus":"START"}
2019-06-09 09:58:32 AUDIT audit:93 - {"time":"June 9, 2019 2:58:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851265423579754","opStatus":"SUCCESS","opTime":"190 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-09 09:58:32 AUDIT audit:72 - {"time":"June 9, 2019 2:58:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851265626366041","opStatus":"START"}
2019-06-09 09:58:32 AUDIT audit:93 - {"time":"June 9, 2019 2:58:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"4851265626366041","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, 5 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 #3572
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/3572/display/redirect>
------------------------------------------
[...truncated 277.92 KB...]
|30.377622377622377|2011-01-01 00:00:...|
|30.450592885375492|2009-01-01 00:00:...|
|30.762295081967213|2002-01-01 00:00:...|
|30.321888412017167|2004-01-01 00:00:...|
|30.440613026819925|2000-01-01 00:00:...|
|30.131687242798353|2008-01-01 00:00:...|
|29.836909871244636|2012-01-01 00:00:...|
|29.714285714285715|2007-01-01 00:00:...|
|29.318181818181817|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-08 09:43:57 AUDIT audit:72 - {"time":"June 8, 2019 2:43:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16623272363847691","opStatus":"START"}
2019-06-08 09:43:57 AUDIT audit:93 - {"time":"June 8, 2019 2:43:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16623272363847691","opStatus":"SUCCESS","opTime":"265 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-08 09:43:57 AUDIT audit:72 - {"time":"June 8, 2019 2:43:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623272744345641","opStatus":"START"}
2019-06-08 09:43:58 AUDIT audit:93 - {"time":"June 8, 2019 2:43:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623272744345641","opStatus":"SUCCESS","opTime":"73 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-08 09:43:58 AUDIT audit:72 - {"time":"June 8, 2019 2:43:58 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16623272819193788","opStatus":"START"}
2019-06-08 09:43:58 AUDIT audit:93 - {"time":"June 8, 2019 2:43:58 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16623272819193788","opStatus":"SUCCESS","opTime":"888 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.07KB","IndexSize":"720.0B"}}
2019-06-08 09:43:58 AUDIT audit:72 - {"time":"June 8, 2019 2:43:58 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16623273714250525","opStatus":"START"}
2019-06-08 09:44:01 AUDIT audit:93 - {"time":"June 8, 2019 2:44:01 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16623273714250525","opStatus":"SUCCESS","opTime":"2175 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.346
time for query on table without lucene datamap table:0.21
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name6|
|which test1 good9|who and name1|
|which test1 good4|who and name2|
|which test1 good9|who and name7|
|which test1 good5|who and name2|
|which test1 good2|who and name6|
|which test1 good9|who and name1|
|which test1 good4|who and name2|
|which test1 good9|who and name7|
|which test1 good5|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name6|
|which test1 good9|who and name1|
|which test1 good4|who and name2|
|which test1 good9|who and name7|
|which test1 good1|who and name6|
|which test1 good5|who and name2|
|which test1 good2|who and name6|
|which test1 good9|who and name1|
|which test1 good4|who and name2|
|which test1 good9|who and name7|
+-----------------+-------------+
2019-06-08 09:44:02 AUDIT audit:72 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16623276813185383","opStatus":"START"}
2019-06-08 09:44:02 AUDIT audit:93 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16623276813185383","opStatus":"SUCCESS","opTime":"109 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-08 09:44:02 AUDIT audit:72 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623276938278154","opStatus":"START"}
2019-06-08 09:44:02 AUDIT audit:93 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623276938278154","opStatus":"SUCCESS","opTime":"71 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-08 09:44:02 AUDIT audit:72 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277014961553","opStatus":"START"}
2019-06-08 09:44:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-08 09:44:02 AUDIT audit:93 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277014961553","opStatus":"SUCCESS","opTime":"224 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-08 09:44:02 AUDIT audit:72 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277244503966","opStatus":"START"}
2019-06-08 09:44:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-08 09:44:02 AUDIT audit:93 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277244503966","opStatus":"SUCCESS","opTime":"230 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-08 09:44:02 AUDIT audit:72 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277481692384","opStatus":"START"}
2019-06-08 09:44:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-08 09:44:02 AUDIT audit:93 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277481692384","opStatus":"SUCCESS","opTime":"206 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-08 09:44:02 AUDIT audit:72 - {"time":"June 8, 2019 2:44:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277693610544","opStatus":"START"}
2019-06-08 09:44:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-08 09:44:03 AUDIT audit:93 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623277693610544","opStatus":"SUCCESS","opTime":"207 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-08 09:44:03 AUDIT audit:72 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623277966948738","opStatus":"START"}
2019-06-08 09:44:03 AUDIT audit:93 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623277966948738","opStatus":"SUCCESS","opTime":"66 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-08 09:44:03 AUDIT audit:72 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623278110381883","opStatus":"START"}
2019-06-08 09:44:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-08 09:44:03 AUDIT audit:93 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623278110381883","opStatus":"SUCCESS","opTime":"207 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-08 09:44:03 AUDIT audit:72 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623278323171886","opStatus":"START"}
2019-06-08 09:44:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-08 09:44:03 AUDIT audit:93 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623278323171886","opStatus":"SUCCESS","opTime":"217 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-08 09:44:03 AUDIT audit:72 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16623278595019871","opStatus":"START"}
2019-06-08 09:44:03 AUDIT audit:93 - {"time":"June 8, 2019 2:44:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16623278595019871","opStatus":"SUCCESS","opTime":"99 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-08 09:44:04 AUDIT audit:72 - {"time":"June 8, 2019 2:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623278979505270","opStatus":"START"}
2019-06-08 09:44:04 AUDIT audit:93 - {"time":"June 8, 2019 2:44:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16623278979505270","opStatus":"SUCCESS","opTime":"87 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-08 09:44:04 AUDIT audit:72 - {"time":"June 8, 2019 2:44:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623279085398319","opStatus":"START"}
2019-06-08 09:44:04 AUDIT audit:93 - {"time":"June 8, 2019 2:44:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623279085398319","opStatus":"SUCCESS","opTime":"189 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-08 09:44:04 AUDIT audit:72 - {"time":"June 8, 2019 2:44:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623279287255227","opStatus":"START"}
2019-06-08 09:44:04 AUDIT audit:93 - {"time":"June 8, 2019 2:44:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16623279287255227","opStatus":"SUCCESS","opTime":"206 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, 39 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 #3571
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/3571/display/redirect>
------------------------------------------
[...truncated 277.29 KB...]
| 27.7165991902834|2017-01-01 00:00:...|
|30.205128205128204|2003-01-01 00:00:...|
|30.481327800829874|2005-01-01 00:00:...|
| 31.56086956521739|2014-01-01 00:00:...|
| 29.83587786259542|2016-01-01 00:00:...|
| 28.91119691119691|2015-01-01 00:00:...|
|29.011070110701105|2011-01-01 00:00:...|
| 28.2|2009-01-01 00:00:...|
|29.614349775784753|2002-01-01 00:00:...|
| 31.08823529411765|2004-01-01 00:00:...|
| 28.6360153256705|2000-01-01 00:00:...|
|28.863468634686345|2008-01-01 00:00:...|
| 29.45689655172414|2012-01-01 00:00:...|
|30.294871794871796|2007-01-01 00:00:...|
|28.610169491525422|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-07 09:53:54 AUDIT audit:72 - {"time":"June 7, 2019 2:53:54 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19933342956964708","opStatus":"START"}
2019-06-07 09:53:54 AUDIT audit:93 - {"time":"June 7, 2019 2:53:54 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19933342956964708","opStatus":"SUCCESS","opTime":"344 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-07 09:53:54 AUDIT audit:72 - {"time":"June 7, 2019 2:53:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933343427428130","opStatus":"START"}
2019-06-07 09:53:54 AUDIT audit:93 - {"time":"June 7, 2019 2:53:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933343427428130","opStatus":"SUCCESS","opTime":"67 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-07 09:53:54 AUDIT audit:72 - {"time":"June 7, 2019 2:53:54 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"19933343497227316","opStatus":"START"}
2019-06-07 09:53:55 AUDIT audit:93 - {"time":"June 7, 2019 2:53:55 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"19933343497227316","opStatus":"SUCCESS","opTime":"847 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"772.42KB","IndexSize":"720.0B"}}
2019-06-07 09:53:55 AUDIT audit:72 - {"time":"June 7, 2019 2:53:55 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"19933344348832180","opStatus":"START"}
2019-06-07 09:53:57 AUDIT audit:93 - {"time":"June 7, 2019 2:53:57 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"19933344348832180","opStatus":"SUCCESS","opTime":"1930 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.21
time for query on table without lucene datamap table:0.154
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name6|
|which test1 good3|who and name5|
|which test1 good5|who and name2|
|which test1 good8|who and name6|
|which test1 good3|who and name5|
|which test1 good5|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name6|
|which test1 good1|who and name0|
|which test1 good3|who and name5|
|which test1 good5|who and name2|
|which test1 good8|who and name6|
|which test1 good1|who and name0|
|which test1 good3|who and name5|
|which test1 good5|who and name2|
+-----------------+-------------+
2019-06-07 09:53:58 AUDIT audit:72 - {"time":"June 7, 2019 2:53:58 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19933346912744622","opStatus":"START"}
2019-06-07 09:53:58 AUDIT audit:93 - {"time":"June 7, 2019 2:53:58 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19933346912744622","opStatus":"SUCCESS","opTime":"84 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-07 09:53:58 AUDIT audit:72 - {"time":"June 7, 2019 2:53:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933347014855149","opStatus":"START"}
2019-06-07 09:53:58 AUDIT audit:93 - {"time":"June 7, 2019 2:53:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933347014855149","opStatus":"SUCCESS","opTime":"63 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-07 09:53:58 AUDIT audit:72 - {"time":"June 7, 2019 2:53:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933347082116283","opStatus":"START"}
2019-06-07 09:53:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-07 09:53:58 AUDIT audit:93 - {"time":"June 7, 2019 2:53:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933347082116283","opStatus":"SUCCESS","opTime":"318 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-07 09:53:58 AUDIT audit:72 - {"time":"June 7, 2019 2:53:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933347404668855","opStatus":"START"}
2019-06-07 09:53:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-07 09:53:59 AUDIT audit:93 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933347404668855","opStatus":"SUCCESS","opTime":"317 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-07 09:53:59 AUDIT audit:72 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933347727021789","opStatus":"START"}
2019-06-07 09:53:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-07 09:53:59 AUDIT audit:93 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933347727021789","opStatus":"SUCCESS","opTime":"299 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-07 09:53:59 AUDIT audit:72 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933348031269225","opStatus":"START"}
2019-06-07 09:53:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-07 09:53:59 AUDIT audit:93 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933348031269225","opStatus":"SUCCESS","opTime":"327 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-07 09:53:59 AUDIT audit:72 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933348423229020","opStatus":"START"}
2019-06-07 09:53:59 AUDIT audit:93 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933348423229020","opStatus":"SUCCESS","opTime":"63 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-07 09:53:59 AUDIT audit:72 - {"time":"June 7, 2019 2:53:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933348542104974","opStatus":"START"}
2019-06-07 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-07 09:54:00 AUDIT audit:93 - {"time":"June 7, 2019 2:54:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933348542104974","opStatus":"SUCCESS","opTime":"314 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-07 09:54:00 AUDIT audit:72 - {"time":"June 7, 2019 2:54:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933348860521347","opStatus":"START"}
2019-06-07 09:54:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-07 09:54:00 AUDIT audit:93 - {"time":"June 7, 2019 2:54:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933348860521347","opStatus":"SUCCESS","opTime":"329 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-07 09:54:00 AUDIT audit:72 - {"time":"June 7, 2019 2:54:00 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19933349256251071","opStatus":"START"}
2019-06-07 09:54:00 AUDIT audit:93 - {"time":"June 7, 2019 2:54:00 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19933349256251071","opStatus":"SUCCESS","opTime":"106 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-07 09:54:00 AUDIT audit:72 - {"time":"June 7, 2019 2:54:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933349687758746","opStatus":"START"}
2019-06-07 09:54:01 AUDIT audit:93 - {"time":"June 7, 2019 2:54:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19933349687758746","opStatus":"SUCCESS","opTime":"82 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-07 09:54:01 AUDIT audit:72 - {"time":"June 7, 2019 2:54:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933349788754744","opStatus":"START"}
2019-06-07 09:54:01 AUDIT audit:93 - {"time":"June 7, 2019 2:54:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933349788754744","opStatus":"SUCCESS","opTime":"297 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-07 09:54:01 AUDIT audit:72 - {"time":"June 7, 2019 2:54:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933350096431681","opStatus":"START"}
2019-06-07 09:54:01 AUDIT audit:93 - {"time":"June 7, 2019 2:54:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19933350096431681","opStatus":"SUCCESS","opTime":"311 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, 37 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