See
<https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3557/display/redirect>
------------------------------------------
[...truncated 277.16 KB...]
| 27.66530612244898|2006-01-01 00:00:...|
| 30.64426877470356|2010-01-01 00:00:...|
| 53.0| null|
| 30.49808429118774|2018-01-01 00:00:...|
|28.684426229508198|2017-01-01 00:00:...|
|29.521072796934867|2003-01-01 00:00:...|
| 28.24793388429752|2005-01-01 00:00:...|
| 29.84375|2014-01-01 00:00:...|
|29.496062992125985|2016-01-01 00:00:...|
|30.129310344827587|2015-01-01 00:00:...|
| 32.2570281124498|2011-01-01 00:00:...|
|30.177966101694917|2009-01-01 00:00:...|
|31.352059925093634|2002-01-01 00:00:...|
|29.159362549800797|2004-01-01 00:00:...|
|29.545833333333334|2000-01-01 00:00:...|
| 29.69291338582677|2008-01-01 00:00:...|
|29.055335968379445|2012-01-01 00:00:...|
|29.353909465020575|2007-01-01 00:00:...|
|30.891304347826086|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-05-30 12:54:45 AUDIT audit:72 - {"time":"May 30, 2019 5:54:45 AM
PDT","username":"jenkins","opName":"DROP
TABLE","opId":"15857120534444953","opStatus":"START"}
2019-05-30 12:54:46 AUDIT audit:93 - {"time":"May 30, 2019 5:54:46 AM
PDT","username":"jenkins","opName":"DROP
TABLE","opId":"15857120534444953","opStatus":"SUCCESS","opTime":"462
ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-05-30 12:54:46 AUDIT audit:72 - {"time":"May 30, 2019 5:54:46 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857121111076412","opStatus":"START"}
2019-05-30 12:54:46 AUDIT audit:93 - {"time":"May 30, 2019 5:54:46 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857121111076412","opStatus":"SUCCESS","opTime":"78
ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-30 12:54:46 AUDIT audit:72 - {"time":"May 30, 2019 5:54:46 AM
PDT","username":"jenkins","opName":"LOAD DATA
OVERWRITE","opId":"15857121191320776","opStatus":"START"}
2019-05-30 12:54:47 AUDIT audit:93 - {"time":"May 30, 2019 5:54:47 AM
PDT","username":"jenkins","opName":"LOAD DATA
OVERWRITE","opId":"15857121191320776","opStatus":"SUCCESS","opTime":"674
ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"772.14KB","IndexSize":"720.0B"}}
2019-05-30 12:54:47 AUDIT audit:72 - {"time":"May 30, 2019 5:54:47 AM
PDT","username":"jenkins","opName":"CREATE
DATAMAP","opId":"15857121870464873","opStatus":"START"}
2019-05-30 12:54:49 AUDIT audit:93 - {"time":"May 30, 2019 5:54:49 AM
PDT","username":"jenkins","opName":"CREATE
DATAMAP","opId":"15857121870464873","opStatus":"SUCCESS","opTime":"2210
ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id
, name"}}
+--------+
|count(1)|
+--------+
| 6|
+--------+
+--------+
|count(1)|
+--------+
| 6|
+--------+
time for query on table with lucene datamap table:0.338
time for query on table without lucene datamap table:0.207
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name2|
|which test1 good3|who and name2|
|which test1 good2|who and name2|
|which test1 good3|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good1|who and name0|
|which test1 good2|who and name2|
|which test1 good3|who and name2|
|which test1 good1|who and name0|
|which test1 good2|who and name2|
|which test1 good3|who and name2|
+-----------------+-------------+
2019-05-30 12:54:50 AUDIT audit:72 - {"time":"May 30, 2019 5:54:50 AM
PDT","username":"jenkins","opName":"DROP
TABLE","opId":"15857125076545434","opStatus":"START"}
2019-05-30 12:54:50 AUDIT audit:93 - {"time":"May 30, 2019 5:54:50 AM
PDT","username":"jenkins","opName":"DROP
TABLE","opId":"15857125076545434","opStatus":"SUCCESS","opTime":"151
ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-05-30 12:54:50 AUDIT audit:72 - {"time":"May 30, 2019 5:54:50 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857125241534669","opStatus":"START"}
2019-05-30 12:54:50 AUDIT audit:93 - {"time":"May 30, 2019 5:54:50 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857125241534669","opStatus":"SUCCESS","opTime":"72
ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-30 12:54:50 AUDIT audit:72 - {"time":"May 30, 2019 5:54:50 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857125317936597","opStatus":"START"}
2019-05-30 12:54:50 ERROR DataLoadExecutor:55 - Data Load is partially success
for table origin_table
2019-05-30 12:54:50 AUDIT audit:93 - {"time":"May 30, 2019 5:54:50 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857125317936597","opStatus":"SUCCESS","opTime":"233
ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-30 12:54:50 AUDIT audit:72 - {"time":"May 30, 2019 5:54:50 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857125556998546","opStatus":"START"}
2019-05-30 12:54:50 ERROR DataLoadExecutor:55 - Data Load is partially success
for table origin_table
2019-05-30 12:54:51 AUDIT audit:93 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857125556998546","opStatus":"SUCCESS","opTime":"228
ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-30 12:54:51 AUDIT audit:72 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857125791370238","opStatus":"START"}
2019-05-30 12:54:51 ERROR DataLoadExecutor:55 - Data Load is partially success
for table origin_table
2019-05-30 12:54:51 AUDIT audit:93 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857125791370238","opStatus":"SUCCESS","opTime":"221
ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-30 12:54:51 AUDIT audit:72 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857126019348685","opStatus":"START"}
2019-05-30 12:54:51 ERROR DataLoadExecutor:55 - Data Load is partially success
for table origin_table
2019-05-30 12:54:51 AUDIT audit:93 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857126019348685","opStatus":"SUCCESS","opTime":"241
ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-30 12:54:51 AUDIT audit:72 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857126329493426","opStatus":"START"}
2019-05-30 12:54:51 AUDIT audit:93 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857126329493426","opStatus":"SUCCESS","opTime":"84
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-05-30 12:54:51 AUDIT audit:72 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857126496346610","opStatus":"START"}
2019-05-30 12:54:51 ERROR DataLoadExecutor:55 - Data Load is partially success
for table origin_table
2019-05-30 12:54:51 AUDIT audit:93 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857126496346610","opStatus":"SUCCESS","opTime":"215
ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-30 12:54:51 AUDIT audit:72 - {"time":"May 30, 2019 5:54:51 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857126716753646","opStatus":"START"}
2019-05-30 12:54:52 ERROR DataLoadExecutor:55 - Data Load is partially success
for table origin_table
2019-05-30 12:54:52 AUDIT audit:93 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857126716753646","opStatus":"SUCCESS","opTime":"217
ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-05-30 12:54:52 AUDIT audit:72 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"DROP
TABLE","opId":"15857126987155166","opStatus":"START"}
2019-05-30 12:54:52 AUDIT audit:93 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"DROP
TABLE","opId":"15857126987155166","opStatus":"SUCCESS","opTime":"145
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-05-30 12:54:52 AUDIT audit:72 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857127388602975","opStatus":"START"}
2019-05-30 12:54:52 AUDIT audit:93 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"CREATE
TABLE","opId":"15857127388602975","opStatus":"SUCCESS","opTime":"83
ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-30 12:54:52 AUDIT audit:72 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857127494619197","opStatus":"START"}
2019-05-30 12:54:52 AUDIT audit:93 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857127494619197","opStatus":"SUCCESS","opTime":"201
ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-05-30 12:54:52 AUDIT audit:72 - {"time":"May 30, 2019 5:54:52 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857127708421362","opStatus":"START"}
2019-05-30 12:54:53 AUDIT audit:93 - {"time":"May 30, 2019 5:54:53 AM
PDT","username":"jenkins","opName":"LOAD
DATA","opId":"15857127708421362","opStatus":"SUCCESS","opTime":"199
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, 41 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
