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/09/09 09:39:56 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3726
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3726/display/redirect>
------------------------------------------
[...truncated 264.25 KB...]
2019-09-09 09:40:00 AUDIT audit:93 - {"time":"September 9, 2019 2:40:00 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"1208206960162042","opStatus":"SUCCESS","opTime":"563 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.39KB","IndexSize":"720.0B"}}
2019-09-09 09:40:00 AUDIT audit:72 - {"time":"September 9, 2019 2:40:00 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"1208207529307419","opStatus":"START"}
2019-09-09 09:40:02 AUDIT audit:93 - {"time":"September 9, 2019 2:40:02 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"1208207529307419","opStatus":"SUCCESS","opTime":"1662 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.255
time for query on table without lucene datamap table:0.141
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name7|
|which test1 good3|who and name1|
|which test1 good4|who and name1|
|which test1 good5|who and name7|
|which test1 good4|who and name7|
|which test1 good3|who and name1|
|which test1 good4|who and name1|
|which test1 good5|who and name7|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name7|
|which test1 good3|who and name1|
|which test1 good4|who and name1|
|which test1 good5|who and name7|
|which test1 good4|who and name7|
|which test1 good3|who and name1|
|which test1 good4|who and name1|
|which test1 good5|who and name7|
+-----------------+-------------+
2019-09-09 09:40:03 AUDIT audit:72 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1208209961295965","opStatus":"START"}
2019-09-09 09:40:03 AUDIT audit:93 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1208209961295965","opStatus":"SUCCESS","opTime":"89 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-09-09 09:40:03 AUDIT audit:72 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208210061516888","opStatus":"START"}
2019-09-09 09:40:03 AUDIT audit:93 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208210061516888","opStatus":"SUCCESS","opTime":"58 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-09 09:40:03 AUDIT audit:72 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210122933185","opStatus":"START"}
2019-09-09 09:40:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-09 09:40:03 AUDIT audit:93 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210122933185","opStatus":"SUCCESS","opTime":"197 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-09 09:40:03 AUDIT audit:72 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210325767649","opStatus":"START"}
2019-09-09 09:40:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-09 09:40:03 AUDIT audit:93 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210325767649","opStatus":"SUCCESS","opTime":"142 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-09 09:40:03 AUDIT audit:72 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210473262266","opStatus":"START"}
2019-09-09 09:40:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-09 09:40:03 AUDIT audit:93 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210473262266","opStatus":"SUCCESS","opTime":"141 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-09 09:40:03 AUDIT audit:72 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210619468570","opStatus":"START"}
2019-09-09 09:40:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-09 09:40:03 AUDIT audit:93 - {"time":"September 9, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210619468570","opStatus":"SUCCESS","opTime":"141 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-09-09 09:40:04 AUDIT audit:72 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208210813918532","opStatus":"START"}
2019-09-09 09:40:04 AUDIT audit:93 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208210813918532","opStatus":"SUCCESS","opTime":"43 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-09-09 09:40:04 AUDIT audit:72 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210980955572","opStatus":"START"}
2019-09-09 09:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-09 09:40:04 AUDIT audit:93 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208210980955572","opStatus":"SUCCESS","opTime":"128 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-09 09:40:04 AUDIT audit:72 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208211113465925","opStatus":"START"}
2019-09-09 09:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-09 09:40:04 AUDIT audit:93 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208211113465925","opStatus":"SUCCESS","opTime":"140 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-09-09 09:40:04 AUDIT audit:72 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1208211304377604","opStatus":"START"}
2019-09-09 09:40:04 AUDIT audit:93 - {"time":"September 9, 2019 2:40:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1208211304377604","opStatus":"SUCCESS","opTime":"79 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
Running SQL on carbon files directly
+------+---+------+
| name|age|height|
+------+---+------+
|robot0| 0| 0.0|
|robot1| 1| 0.5|
|robot2| 2| 1.0|
|robot3| 3| 1.5|
|robot4| 4| 2.0|
|robot5| 5| 2.5|
|robot6| 6| 3.0|
|robot7| 7| 3.5|
|robot8| 8| 4.0|
|robot9| 9| 4.5|
+------+---+------+
[32m- DirectSQLExample[0m
2019-09-09 09:40:05 AUDIT audit:72 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208211880707599","opStatus":"START"}
2019-09-09 09:40:05 AUDIT audit:93 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208211880707599","opStatus":"SUCCESS","opTime":"50 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-09 09:40:05 AUDIT audit:72 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208211992932735","opStatus":"START"}
2019-09-09 09:40:05 AUDIT audit:93 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208211992932735","opStatus":"SUCCESS","opTime":"164 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-09-09 09:40:05 AUDIT audit:72 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208212166578593","opStatus":"START"}
2019-09-09 09:40:05 AUDIT audit:93 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208212166578593","opStatus":"SUCCESS","opTime":"136 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|
+---+---------+--------+
2019-09-09 09:40:05 AUDIT audit:72 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208212397995017","opStatus":"START"}
2019-09-09 09:40:05 AUDIT audit:93 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1208212397995017","opStatus":"SUCCESS","opTime":"56 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-09-09 09:40:05 AUDIT audit:72 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208212458054898","opStatus":"START"}
2019-09-09 09:40:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-09-09 09:40:05 AUDIT audit:93 - {"time":"September 9, 2019 2:40:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1208212458054898","opStatus":"SUCCESS","opTime":"191 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
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:171)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[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 1 minute, 49 seconds.[0m
[36mTotal number of tests run: 21[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 20, 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 #3729
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/3729/display/redirect>
------------------------------------------
[...truncated 265.74 KB...]
| 12|
+--------+
+--------+
|count(1)|
+--------+
| 12|
+--------+
time for query on table with lucene datamap table:0.268
time for query on table without lucene datamap table:0.151
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name4|
|which test1 good3|who and name1|
|which test1 good5|who and name6|
|which test1 good9|who and name6|
|which test1 good5|who and name6|
|which test1 good2|who and name3|
|which test1 good4|who and name4|
|which test1 good3|who and name1|
|which test1 good5|who and name6|
|which test1 good9|who and name6|
|which test1 good5|who and name6|
|which test1 good2|who and name3|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name4|
|which test1 good3|who and name1|
|which test1 good5|who and name6|
|which test1 good9|who and name6|
|which test1 good5|who and name6|
|which test1 good2|who and name3|
|which test1 good4|who and name4|
|which test1 good3|who and name1|
|which test1 good5|who and name6|
|which test1 good9|who and name6|
+-----------------+-------------+
2019-09-11 09:39:48 AUDIT audit:72 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1381130569430757","opStatus":"START"}
2019-09-11 09:39:48 AUDIT audit:93 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1381130569430757","opStatus":"SUCCESS","opTime":"84 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-09-11 09:39:48 AUDIT audit:72 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381130664562706","opStatus":"START"}
2019-09-11 09:39:48 AUDIT audit:93 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381130664562706","opStatus":"SUCCESS","opTime":"55 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-11 09:39:48 AUDIT audit:72 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381130723661076","opStatus":"START"}
2019-09-11 09:39:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 09:39:48 AUDIT audit:93 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381130723661076","opStatus":"SUCCESS","opTime":"193 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 09:39:48 AUDIT audit:72 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381130921623460","opStatus":"START"}
2019-09-11 09:39:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 09:39:48 AUDIT audit:93 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381130921623460","opStatus":"SUCCESS","opTime":"133 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 09:39:48 AUDIT audit:72 - {"time":"September 11, 2019 2:39:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131059735376","opStatus":"START"}
2019-09-11 09:39:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 09:39:49 AUDIT audit:93 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131059735376","opStatus":"SUCCESS","opTime":"144 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 09:39:49 AUDIT audit:72 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131208464293","opStatus":"START"}
2019-09-11 09:39:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 09:39:49 AUDIT audit:93 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131208464293","opStatus":"SUCCESS","opTime":"132 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-09-11 09:39:49 AUDIT audit:72 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381131389041918","opStatus":"START"}
2019-09-11 09:39:49 AUDIT audit:93 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381131389041918","opStatus":"SUCCESS","opTime":"45 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-09-11 09:39:49 AUDIT audit:72 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131541922949","opStatus":"START"}
2019-09-11 09:39:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 09:39:49 AUDIT audit:93 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131541922949","opStatus":"SUCCESS","opTime":"127 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 09:39:49 AUDIT audit:72 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131673053289","opStatus":"START"}
2019-09-11 09:39:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 09:39:49 AUDIT audit:93 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381131673053289","opStatus":"SUCCESS","opTime":"135 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-09-11 09:39:49 AUDIT audit:72 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1381131859461285","opStatus":"START"}
2019-09-11 09:39:49 AUDIT audit:93 - {"time":"September 11, 2019 2:39:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"1381131859461285","opStatus":"SUCCESS","opTime":"78 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
Running SQL on carbon files directly
+------+---+------+
| name|age|height|
+------+---+------+
|robot0| 0| 0.0|
|robot1| 1| 0.5|
|robot2| 2| 1.0|
|robot3| 3| 1.5|
|robot4| 4| 2.0|
|robot5| 5| 2.5|
|robot6| 6| 3.0|
|robot7| 7| 3.5|
|robot8| 8| 4.0|
|robot9| 9| 4.5|
+------+---+------+
[32m- DirectSQLExample[0m
2019-09-11 09:39:50 AUDIT audit:72 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381132439453245","opStatus":"START"}
2019-09-11 09:39:50 AUDIT audit:93 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381132439453245","opStatus":"SUCCESS","opTime":"48 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-11 09:39:50 AUDIT audit:72 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381132548370585","opStatus":"START"}
2019-09-11 09:39:50 AUDIT audit:93 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381132548370585","opStatus":"SUCCESS","opTime":"149 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-09-11 09:39:50 AUDIT audit:72 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381132707405346","opStatus":"START"}
2019-09-11 09:39:50 AUDIT audit:93 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381132707405346","opStatus":"SUCCESS","opTime":"136 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|
+---+---------+--------+
2019-09-11 09:39:50 AUDIT audit:72 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381132944159355","opStatus":"START"}
2019-09-11 09:39:50 AUDIT audit:93 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"1381132944159355","opStatus":"SUCCESS","opTime":"43 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-09-11 09:39:50 AUDIT audit:72 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381132991251850","opStatus":"START"}
2019-09-11 09:39:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-09-11 09:39:50 AUDIT audit:93 - {"time":"September 11, 2019 2:39:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"1381132991251850","opStatus":"SUCCESS","opTime":"190 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
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:171)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[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 1 minute, 47 seconds.[0m
[36mTotal number of tests run: 21[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 20, 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 #3728
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/3728/display/redirect>
------------------------------------------
[...truncated 265.84 KB...]
[32m- TimeSeriesPreAggregateTableExample[0m
2019-09-11 08:07:55 AUDIT audit:72 - {"time":"September 11, 2019 1:07:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180592290173320","opStatus":"START"}
2019-09-11 08:07:55 AUDIT audit:93 - {"time":"September 11, 2019 1:07:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180592290173320","opStatus":"SUCCESS","opTime":"67 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-11 08:07:55 AUDIT audit:72 - {"time":"September 11, 2019 1:07:55 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"28180592359754067","opStatus":"START"}
2019-09-11 08:07:55 AUDIT audit:93 - {"time":"September 11, 2019 1:07:55 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"28180592359754067","opStatus":"SUCCESS","opTime":"483 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.40KB","IndexSize":"720.0B"}}
2019-09-11 08:07:55 AUDIT audit:72 - {"time":"September 11, 2019 1:07:55 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"28180592845856096","opStatus":"START"}
2019-09-11 08:07:57 AUDIT audit:93 - {"time":"September 11, 2019 1:07:57 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"28180592845856096","opStatus":"SUCCESS","opTime":"1539 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.217
time for query on table without lucene datamap table:0.137
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name0|
|which test1 good5|who and name6|
|which test1 good8|who and name3|
|which test1 good8|who and name0|
|which test1 good5|who and name6|
|which test1 good8|who and name3|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name0|
|which test1 good5|who and name6|
|which test1 good8|who and name3|
|which test1 good8|who and name0|
|which test1 good5|who and name6|
|which test1 good8|who and name3|
+-----------------+-------------+
2019-09-11 08:07:57 AUDIT audit:72 - {"time":"September 11, 2019 1:07:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"28180595018419379","opStatus":"START"}
2019-09-11 08:07:58 AUDIT audit:93 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"28180595018419379","opStatus":"SUCCESS","opTime":"274 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-09-11 08:07:58 AUDIT audit:72 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180595309087396","opStatus":"START"}
2019-09-11 08:07:58 AUDIT audit:93 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180595309087396","opStatus":"SUCCESS","opTime":"57 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-11 08:07:58 AUDIT audit:72 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595368982474","opStatus":"START"}
2019-09-11 08:07:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 08:07:58 AUDIT audit:93 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595368982474","opStatus":"SUCCESS","opTime":"179 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 08:07:58 AUDIT audit:72 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595551805878","opStatus":"START"}
2019-09-11 08:07:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 08:07:58 AUDIT audit:93 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595551805878","opStatus":"SUCCESS","opTime":"179 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 08:07:58 AUDIT audit:72 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595735340480","opStatus":"START"}
2019-09-11 08:07:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 08:07:58 AUDIT audit:93 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595735340480","opStatus":"SUCCESS","opTime":"126 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 08:07:58 AUDIT audit:72 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595864639611","opStatus":"START"}
2019-09-11 08:07:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 08:07:58 AUDIT audit:93 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180595864639611","opStatus":"SUCCESS","opTime":"123 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-09-11 08:07:58 AUDIT audit:72 - {"time":"September 11, 2019 1:07:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180596045804001","opStatus":"START"}
2019-09-11 08:07:59 AUDIT audit:93 - {"time":"September 11, 2019 1:07:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180596045804001","opStatus":"SUCCESS","opTime":"62 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-09-11 08:07:59 AUDIT audit:72 - {"time":"September 11, 2019 1:07:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180596230391959","opStatus":"START"}
2019-09-11 08:07:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 08:07:59 AUDIT audit:93 - {"time":"September 11, 2019 1:07:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180596230391959","opStatus":"SUCCESS","opTime":"138 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-11 08:07:59 AUDIT audit:72 - {"time":"September 11, 2019 1:07:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180596372740111","opStatus":"START"}
2019-09-11 08:07:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-11 08:07:59 AUDIT audit:93 - {"time":"September 11, 2019 1:07:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180596372740111","opStatus":"SUCCESS","opTime":"142 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-09-11 08:07:59 AUDIT audit:72 - {"time":"September 11, 2019 1:07:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"28180596566244488","opStatus":"START"}
2019-09-11 08:07:59 AUDIT audit:93 - {"time":"September 11, 2019 1:07:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"28180596566244488","opStatus":"SUCCESS","opTime":"96 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
Running SQL on carbon files directly
+------+---+------+
| name|age|height|
+------+---+------+
|robot0| 0| 0.0|
|robot1| 1| 0.5|
|robot2| 2| 1.0|
|robot3| 3| 1.5|
|robot4| 4| 2.0|
|robot5| 5| 2.5|
|robot6| 6| 3.0|
|robot7| 7| 3.5|
|robot8| 8| 4.0|
|robot9| 9| 4.5|
+------+---+------+
[32m- DirectSQLExample[0m
2019-09-11 08:08:00 AUDIT audit:72 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180597139144035","opStatus":"START"}
2019-09-11 08:08:00 AUDIT audit:93 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180597139144035","opStatus":"SUCCESS","opTime":"126 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-11 08:08:00 AUDIT audit:72 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180597333708700","opStatus":"START"}
2019-09-11 08:08:00 AUDIT audit:93 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180597333708700","opStatus":"SUCCESS","opTime":"143 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-09-11 08:08:00 AUDIT audit:72 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180597484737244","opStatus":"START"}
2019-09-11 08:08:00 AUDIT audit:93 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180597484737244","opStatus":"SUCCESS","opTime":"140 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|
+---+---------+--------+
2019-09-11 08:08:00 AUDIT audit:72 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180597714098546","opStatus":"START"}
2019-09-11 08:08:00 AUDIT audit:93 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"28180597714098546","opStatus":"SUCCESS","opTime":"50 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-09-11 08:08:00 AUDIT audit:72 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180597768831112","opStatus":"START"}
2019-09-11 08:08:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-09-11 08:08:00 AUDIT audit:93 - {"time":"September 11, 2019 1:08:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"28180597768831112","opStatus":"SUCCESS","opTime":"211 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
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:171)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[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, 13 seconds.[0m
[36mTotal number of tests run: 21[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 20, 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 #3727
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/3727/display/redirect>
------------------------------------------
[...truncated 266.25 KB...]
+--------+
|count(1)|
+--------+
| 14|
+--------+
time for query on table with lucene datamap table:0.259
time for query on table without lucene datamap table:0.184
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name4|
|which test1 good0|who and name6|
|which test1 good3|who and name6|
|which test1 good4|who and name7|
|which test1 good9|who and name0|
|which test1 good9|who and name5|
|which test1 good4|who and name5|
|which test1 good0|who and name4|
|which test1 good0|who and name6|
|which test1 good3|who and name6|
|which test1 good4|who and name7|
|which test1 good9|who and name0|
|which test1 good9|who and name5|
|which test1 good4|who and name5|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name4|
|which test1 good0|who and name6|
|which test1 good3|who and name6|
|which test1 good4|who and name7|
|which test1 good9|who and name0|
|which test1 good9|who and name5|
|which test1 good4|who and name5|
|which test1 good0|who and name4|
|which test1 good0|who and name6|
|which test1 good3|who and name6|
+-----------------+-------------+
2019-09-10 09:45:33 AUDIT audit:72 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"24744760599848052","opStatus":"START"}
2019-09-10 09:45:33 AUDIT audit:93 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"24744760599848052","opStatus":"SUCCESS","opTime":"111 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-09-10 09:45:33 AUDIT audit:72 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744760723288006","opStatus":"START"}
2019-09-10 09:45:33 AUDIT audit:93 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744760723288006","opStatus":"SUCCESS","opTime":"49 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-10 09:45:33 AUDIT audit:72 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744760776593478","opStatus":"START"}
2019-09-10 09:45:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-10 09:45:33 AUDIT audit:93 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744760776593478","opStatus":"SUCCESS","opTime":"192 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-10 09:45:33 AUDIT audit:72 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744760972819448","opStatus":"START"}
2019-09-10 09:45:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-10 09:45:33 AUDIT audit:93 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744760972819448","opStatus":"SUCCESS","opTime":"145 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-10 09:45:33 AUDIT audit:72 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761122490873","opStatus":"START"}
2019-09-10 09:45:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-10 09:45:33 AUDIT audit:93 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761122490873","opStatus":"SUCCESS","opTime":"132 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-10 09:45:33 AUDIT audit:72 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761260303627","opStatus":"START"}
2019-09-10 09:45:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-10 09:45:33 AUDIT audit:93 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761260303627","opStatus":"SUCCESS","opTime":"148 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-09-10 09:45:33 AUDIT audit:72 - {"time":"September 10, 2019 2:45:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744761478720225","opStatus":"START"}
2019-09-10 09:45:34 AUDIT audit:93 - {"time":"September 10, 2019 2:45:34 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744761478720225","opStatus":"SUCCESS","opTime":"53 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-09-10 09:45:34 AUDIT audit:72 - {"time":"September 10, 2019 2:45:34 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761662652480","opStatus":"START"}
2019-09-10 09:45:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-10 09:45:34 AUDIT audit:93 - {"time":"September 10, 2019 2:45:34 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761662652480","opStatus":"SUCCESS","opTime":"144 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-09-10 09:45:34 AUDIT audit:72 - {"time":"September 10, 2019 2:45:34 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761810786917","opStatus":"START"}
2019-09-10 09:45:34 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-09-10 09:45:34 AUDIT audit:93 - {"time":"September 10, 2019 2:45:34 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744761810786917","opStatus":"SUCCESS","opTime":"92 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-09-10 09:45:34 AUDIT audit:72 - {"time":"September 10, 2019 2:45:34 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"24744761961420484","opStatus":"START"}
2019-09-10 09:45:34 AUDIT audit:93 - {"time":"September 10, 2019 2:45:34 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"24744761961420484","opStatus":"SUCCESS","opTime":"138 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
Running SQL on carbon files directly
+------+---+------+
| name|age|height|
+------+---+------+
|robot0| 0| 0.0|
|robot1| 1| 0.5|
|robot2| 2| 1.0|
|robot3| 3| 1.5|
|robot4| 4| 2.0|
|robot5| 5| 2.5|
|robot6| 6| 3.0|
|robot7| 7| 3.5|
|robot8| 8| 4.0|
|robot9| 9| 4.5|
+------+---+------+
[32m- DirectSQLExample[0m
2019-09-10 09:45:35 AUDIT audit:72 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744762638235042","opStatus":"START"}
2019-09-10 09:45:35 AUDIT audit:93 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744762638235042","opStatus":"SUCCESS","opTime":"76 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-09-10 09:45:35 AUDIT audit:72 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744762781698835","opStatus":"START"}
2019-09-10 09:45:35 AUDIT audit:93 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744762781698835","opStatus":"SUCCESS","opTime":"128 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-09-10 09:45:35 AUDIT audit:72 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744762919284730","opStatus":"START"}
2019-09-10 09:45:35 AUDIT audit:93 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744762919284730","opStatus":"SUCCESS","opTime":"131 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|
+---+---------+--------+
2019-09-10 09:45:35 AUDIT audit:72 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744763151018573","opStatus":"START"}
2019-09-10 09:45:35 AUDIT audit:93 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"24744763151018573","opStatus":"SUCCESS","opTime":"61 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-09-10 09:45:35 AUDIT audit:72 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744763217092986","opStatus":"START"}
2019-09-10 09:45:35 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-09-10 09:45:35 AUDIT audit:93 - {"time":"September 10, 2019 2:45:35 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"24744763217092986","opStatus":"SUCCESS","opTime":"211 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
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:171)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)[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, 23 seconds.[0m
[36mTotal number of tests run: 21[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 20, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results