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/07/18 09:59:46 UTC

Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3646

See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3646/display/redirect>

------------------------------------------
[...truncated 279.57 KB...]
|count(1)|
+--------+
|      10|
+--------+

+--------+
|count(1)|
+--------+
|      10|
+--------+

time for query on table with lucene datamap table:0.372
time for query on table without lucene datamap table:0.25
+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good9|who and name5|
|which test1 good8|who and name2|
|which test1 good6|who and name0|
|which test1 good5|who and name1|
|which test1 good7|who and name5|
|which test1 good9|who and name5|
|which test1 good8|who and name2|
|which test1 good6|who and name0|
|which test1 good5|who and name1|
|which test1 good7|who and name5|
+-----------------+-------------+

+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good9|who and name5|
|which test1 good8|who and name2|
|which test1 good6|who and name0|
|which test1 good5|who and name1|
|which test1 good7|who and name5|
|which test1 good9|who and name5|
|which test1 good8|who and name2|
|which test1 good6|who and name0|
|which test1 good5|who and name1|
|which test1 good7|who and name5|
+-----------------+-------------+

2019-07-18 09:58:27 AUDIT audit:72 - {"time":"July 18, 2019 2:58:27 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"351281004168694","opStatus":"START"}
2019-07-18 09:58:28 AUDIT audit:93 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"351281004168694","opStatus":"SUCCESS","opTime":"144 ms","table":"default.persontable","extraInfo":{}}
- LuceneDataMapExample
2019-07-18 09:58:28 AUDIT audit:72 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351281166711994","opStatus":"START"}
2019-07-18 09:58:28 AUDIT audit:93 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351281166711994","opStatus":"SUCCESS","opTime":"76 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-18 09:58:28 AUDIT audit:72 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281250721101","opStatus":"START"}
2019-07-18 09:58:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-18 09:58:28 AUDIT audit:93 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281250721101","opStatus":"SUCCESS","opTime":"205 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-18 09:58:28 AUDIT audit:72 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281462141564","opStatus":"START"}
2019-07-18 09:58:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-18 09:58:28 AUDIT audit:93 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281462141564","opStatus":"SUCCESS","opTime":"179 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-18 09:58:28 AUDIT audit:72 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281647538034","opStatus":"START"}
2019-07-18 09:58:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-18 09:58:28 AUDIT audit:93 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281647538034","opStatus":"SUCCESS","opTime":"177 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-18 09:58:28 AUDIT audit:72 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281830972356","opStatus":"START"}
2019-07-18 09:58:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-18 09:58:28 AUDIT audit:93 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351281830972356","opStatus":"SUCCESS","opTime":"163 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-18 09:58:28 AUDIT audit:72 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351282064125809","opStatus":"START"}
2019-07-18 09:58:28 AUDIT audit:93 - {"time":"July 18, 2019 2:58:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351282064125809","opStatus":"SUCCESS","opTime":"72 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-07-18 09:58:29 AUDIT audit:72 - {"time":"July 18, 2019 2:58:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351282226392434","opStatus":"START"}
2019-07-18 09:58:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-18 09:58:29 AUDIT audit:93 - {"time":"July 18, 2019 2:58:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351282226392434","opStatus":"SUCCESS","opTime":"177 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-18 09:58:29 AUDIT audit:72 - {"time":"July 18, 2019 2:58:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351282410593768","opStatus":"START"}
2019-07-18 09:58:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-18 09:58:29 AUDIT audit:93 - {"time":"July 18, 2019 2:58:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351282410593768","opStatus":"SUCCESS","opTime":"185 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      60|
+--------+

2019-07-18 09:58:29 AUDIT audit:72 - {"time":"July 18, 2019 2:58:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"351282674436871","opStatus":"START"}
2019-07-18 09:58:29 AUDIT audit:93 - {"time":"July 18, 2019 2:58:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"351282674436871","opStatus":"SUCCESS","opTime":"156 ms","table":"default.origin_table","extraInfo":{}}
- ExternalTableExample

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	
- CarbonReaderExample
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|
+------+---+------+

- DirectSQLExample
2019-07-18 09:58:30 AUDIT audit:72 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351283516099106","opStatus":"START"}
2019-07-18 09:58:30 AUDIT audit:93 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351283516099106","opStatus":"SUCCESS","opTime":"75 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-18 09:58:30 AUDIT audit:72 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351283607666069","opStatus":"START"}
2019-07-18 09:58:30 AUDIT audit:93 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351283607666069","opStatus":"SUCCESS","opTime":"164 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-07-18 09:58:30 AUDIT audit:72 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351283782670992","opStatus":"START"}
2019-07-18 09:58:30 AUDIT audit:93 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351283782670992","opStatus":"SUCCESS","opTime":"152 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-07-18 09:58:30 AUDIT audit:72 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351284058984192","opStatus":"START"}
2019-07-18 09:58:30 AUDIT audit:93 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"351284058984192","opStatus":"SUCCESS","opTime":"67 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-07-18 09:58:30 AUDIT audit:72 - {"time":"July 18, 2019 2:58:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351284131604769","opStatus":"START"}
2019-07-18 09:58:31 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-07-18 09:58:31 AUDIT audit:93 - {"time":"July 18, 2019 2:58:31 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"351284131604769","opStatus":"SUCCESS","opTime":"197 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
OK
******Total Number Of Rows Fetched ****** 0
- HiveExample *** FAILED ***
  java.lang.AssertionError: assertion failed
  at scala.Predef$.assert(Predef.scala:156)
  at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:171)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
  at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
  at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
  at org.scalatest.Transformer.apply(Transformer.scala:22)
  at org.scalatest.Transformer.apply(Transformer.scala:20)
  ...
Exception encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
          *** ABORTED ***
  java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
  at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)
  at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)
  at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)
  at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  ...
Run completed in 3 minutes, 4 seconds.
Total number of tests run: 21
Suites: completed 1, aborted 1
Tests: succeeded 20, failed 1, canceled 0, ignored 0, pending 0
*** 1 SUITE ABORTED ***
*** 1 TEST FAILED ***
[JENKINS] Recording test results

Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3650

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/3650/display/redirect>

------------------------------------------
[...truncated 279.25 KB...]
2019-07-22 08:37:59 AUDIT audit:93 - {"time":"July 22, 2019 1:37:59 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"23472400623285613","opStatus":"SUCCESS","opTime":"638 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.73KB","IndexSize":"720.0B"}}
2019-07-22 08:37:59 AUDIT audit:72 - {"time":"July 22, 2019 1:37:59 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"23472401267295883","opStatus":"START"}
2019-07-22 08:38:01 AUDIT audit:93 - {"time":"July 22, 2019 1:38:01 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"23472401267295883","opStatus":"SUCCESS","opTime":"2037 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.263
time for query on table without lucene datamap table:0.155
+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good5|who and name5|
|which test1 good3|who and name6|
|which test1 good3|who and name0|
|which test1 good0|who and name7|
|which test1 good5|who and name5|
|which test1 good3|who and name6|
|which test1 good3|who and name0|
|which test1 good0|who and name7|
+-----------------+-------------+

+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good5|who and name5|
|which test1 good3|who and name6|
|which test1 good3|who and name0|
|which test1 good0|who and name7|
|which test1 good5|who and name5|
|which test1 good3|who and name6|
|which test1 good3|who and name0|
|which test1 good0|who and name7|
+-----------------+-------------+

2019-07-22 08:38:02 AUDIT audit:72 - {"time":"July 22, 2019 1:38:02 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"23472404143175044","opStatus":"START"}
2019-07-22 08:38:02 AUDIT audit:93 - {"time":"July 22, 2019 1:38:02 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"23472404143175044","opStatus":"SUCCESS","opTime":"122 ms","table":"default.persontable","extraInfo":{}}
- LuceneDataMapExample
2019-07-22 08:38:02 AUDIT audit:72 - {"time":"July 22, 2019 1:38:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472404285102585","opStatus":"START"}
2019-07-22 08:38:02 AUDIT audit:93 - {"time":"July 22, 2019 1:38:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472404285102585","opStatus":"SUCCESS","opTime":"75 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-22 08:38:02 AUDIT audit:72 - {"time":"July 22, 2019 1:38:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404367745993","opStatus":"START"}
2019-07-22 08:38:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-22 08:38:02 AUDIT audit:93 - {"time":"July 22, 2019 1:38:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404367745993","opStatus":"SUCCESS","opTime":"197 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-22 08:38:02 AUDIT audit:72 - {"time":"July 22, 2019 1:38:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404570969255","opStatus":"START"}
2019-07-22 08:38:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-22 08:38:03 AUDIT audit:93 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404570969255","opStatus":"SUCCESS","opTime":"149 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-22 08:38:03 AUDIT audit:72 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404725062143","opStatus":"START"}
2019-07-22 08:38:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-22 08:38:03 AUDIT audit:93 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404725062143","opStatus":"SUCCESS","opTime":"153 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-22 08:38:03 AUDIT audit:72 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404882022065","opStatus":"START"}
2019-07-22 08:38:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-22 08:38:03 AUDIT audit:93 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472404882022065","opStatus":"SUCCESS","opTime":"151 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-22 08:38:03 AUDIT audit:72 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472405093520464","opStatus":"START"}
2019-07-22 08:38:03 AUDIT audit:93 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472405093520464","opStatus":"SUCCESS","opTime":"67 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-22 08:38:03 AUDIT audit:72 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472405228980782","opStatus":"START"}
2019-07-22 08:38:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-22 08:38:03 AUDIT audit:93 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472405228980782","opStatus":"SUCCESS","opTime":"168 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-22 08:38:03 AUDIT audit:72 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472405403306018","opStatus":"START"}
2019-07-22 08:38:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-22 08:38:03 AUDIT audit:93 - {"time":"July 22, 2019 1:38:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472405403306018","opStatus":"SUCCESS","opTime":"177 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      60|
+--------+

2019-07-22 08:38:04 AUDIT audit:72 - {"time":"July 22, 2019 1:38:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"23472405639337892","opStatus":"START"}
2019-07-22 08:38:04 AUDIT audit:93 - {"time":"July 22, 2019 1:38:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"23472405639337892","opStatus":"SUCCESS","opTime":"134 ms","table":"default.origin_table","extraInfo":{}}
- ExternalTableExample

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	
- CarbonReaderExample
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|
+------+---+------+

- DirectSQLExample
2019-07-22 08:38:04 AUDIT audit:72 - {"time":"July 22, 2019 1:38:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472406368859096","opStatus":"START"}
2019-07-22 08:38:04 AUDIT audit:93 - {"time":"July 22, 2019 1:38:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472406368859096","opStatus":"SUCCESS","opTime":"75 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-22 08:38:04 AUDIT audit:72 - {"time":"July 22, 2019 1:38:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472406463324277","opStatus":"START"}
2019-07-22 08:38:05 AUDIT audit:93 - {"time":"July 22, 2019 1:38:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472406463324277","opStatus":"SUCCESS","opTime":"166 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-07-22 08:38:05 AUDIT audit:72 - {"time":"July 22, 2019 1:38:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472406642874413","opStatus":"START"}
2019-07-22 08:38:05 AUDIT audit:93 - {"time":"July 22, 2019 1:38:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472406642874413","opStatus":"SUCCESS","opTime":"149 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-07-22 08:38:05 AUDIT audit:72 - {"time":"July 22, 2019 1:38:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472406910904436","opStatus":"START"}
2019-07-22 08:38:05 AUDIT audit:93 - {"time":"July 22, 2019 1:38:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"23472406910904436","opStatus":"SUCCESS","opTime":"258 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-07-22 08:38:05 AUDIT audit:72 - {"time":"July 22, 2019 1:38:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472407175592257","opStatus":"START"}
2019-07-22 08:38:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-07-22 08:38:05 AUDIT audit:93 - {"time":"July 22, 2019 1:38:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"23472407175592257","opStatus":"SUCCESS","opTime":"171 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
OK
******Total Number Of Rows Fetched ****** 0
- HiveExample *** FAILED ***
  java.lang.AssertionError: assertion failed
  at scala.Predef$.assert(Predef.scala:156)
  at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:171)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
  at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
  at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
  at org.scalatest.Transformer.apply(Transformer.scala:22)
  at org.scalatest.Transformer.apply(Transformer.scala:20)
  ...
Exception encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
          *** ABORTED ***
  java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
  at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)
  at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)
  at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)
  at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  ...
Run completed in 2 minutes, 34 seconds.
Total number of tests run: 21
Suites: completed 1, aborted 1
Tests: succeeded 20, failed 1, canceled 0, ignored 0, pending 0
*** 1 SUITE ABORTED ***
*** 1 TEST FAILED ***
[JENKINS] Recording test results

Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3649

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/3649/display/redirect>

------------------------------------------
[...truncated 280.12 KB...]

+--------+
|count(1)|
+--------+
|      14|
+--------+

time for query on table with lucene datamap table:0.338
time for query on table without lucene datamap table:0.217
+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good7|who and name1|
|which test1 good2|who and name7|
|which test1 good3|who and name0|
|which test1 good0|who and name5|
|which test1 good8|who and name7|
|which test1 good9|who and name3|
|which test1 good3|who and name3|
|which test1 good7|who and name1|
|which test1 good2|who and name7|
|which test1 good3|who and name0|
|which test1 good0|who and name5|
|which test1 good8|who and name7|
|which test1 good9|who and name3|
|which test1 good3|who and name3|
+-----------------+-------------+

+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good7|who and name1|
|which test1 good2|who and name7|
|which test1 good3|who and name0|
|which test1 good0|who and name5|
|which test1 good8|who and name7|
|which test1 good9|who and name3|
|which test1 good3|who and name3|
|which test1 good7|who and name1|
|which test1 good2|who and name7|
|which test1 good3|who and name0|
+-----------------+-------------+

2019-07-21 09:38:46 AUDIT audit:72 - {"time":"July 21, 2019 2:38:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20338161103241751","opStatus":"START"}
2019-07-21 09:38:46 AUDIT audit:93 - {"time":"July 21, 2019 2:38:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20338161103241751","opStatus":"SUCCESS","opTime":"163 ms","table":"default.persontable","extraInfo":{}}
- LuceneDataMapExample
2019-07-21 09:38:46 AUDIT audit:72 - {"time":"July 21, 2019 2:38:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338161281298302","opStatus":"START"}
2019-07-21 09:38:46 AUDIT audit:93 - {"time":"July 21, 2019 2:38:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338161281298302","opStatus":"SUCCESS","opTime":"188 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-21 09:38:46 AUDIT audit:72 - {"time":"July 21, 2019 2:38:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338161475331420","opStatus":"START"}
2019-07-21 09:38:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-21 09:38:46 AUDIT audit:93 - {"time":"July 21, 2019 2:38:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338161475331420","opStatus":"SUCCESS","opTime":"235 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-21 09:38:46 AUDIT audit:72 - {"time":"July 21, 2019 2:38:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338161717348233","opStatus":"START"}
2019-07-21 09:38:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-21 09:38:47 AUDIT audit:93 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338161717348233","opStatus":"SUCCESS","opTime":"195 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-21 09:38:47 AUDIT audit:72 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338161918994431","opStatus":"START"}
2019-07-21 09:38:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-21 09:38:47 AUDIT audit:93 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338161918994431","opStatus":"SUCCESS","opTime":"180 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-21 09:38:47 AUDIT audit:72 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338162109301925","opStatus":"START"}
2019-07-21 09:38:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-21 09:38:47 AUDIT audit:93 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338162109301925","opStatus":"SUCCESS","opTime":"182 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-21 09:38:47 AUDIT audit:72 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338162383818818","opStatus":"START"}
2019-07-21 09:38:47 AUDIT audit:93 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338162383818818","opStatus":"SUCCESS","opTime":"61 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-21 09:38:47 AUDIT audit:72 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338162543759424","opStatus":"START"}
2019-07-21 09:38:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-21 09:38:47 AUDIT audit:93 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338162543759424","opStatus":"SUCCESS","opTime":"187 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-21 09:38:47 AUDIT audit:72 - {"time":"July 21, 2019 2:38:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338162737758538","opStatus":"START"}
2019-07-21 09:38:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-21 09:38:48 AUDIT audit:93 - {"time":"July 21, 2019 2:38:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338162737758538","opStatus":"SUCCESS","opTime":"174 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      60|
+--------+

2019-07-21 09:38:48 AUDIT audit:72 - {"time":"July 21, 2019 2:38:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20338162980775081","opStatus":"START"}
2019-07-21 09:38:48 AUDIT audit:93 - {"time":"July 21, 2019 2:38:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20338162980775081","opStatus":"SUCCESS","opTime":"132 ms","table":"default.origin_table","extraInfo":{}}
- ExternalTableExample

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	
- CarbonReaderExample
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|
+------+---+------+

- DirectSQLExample
2019-07-21 09:38:48 AUDIT audit:72 - {"time":"July 21, 2019 2:38:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338163766103557","opStatus":"START"}
2019-07-21 09:38:49 AUDIT audit:93 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338163766103557","opStatus":"SUCCESS","opTime":"96 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-21 09:38:49 AUDIT audit:72 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338163884808357","opStatus":"START"}
2019-07-21 09:38:49 AUDIT audit:93 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338163884808357","opStatus":"SUCCESS","opTime":"204 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-07-21 09:38:49 AUDIT audit:72 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338164100035781","opStatus":"START"}
2019-07-21 09:38:49 AUDIT audit:93 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338164100035781","opStatus":"SUCCESS","opTime":"167 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-07-21 09:38:49 AUDIT audit:72 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338164418295165","opStatus":"START"}
2019-07-21 09:38:49 AUDIT audit:93 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20338164418295165","opStatus":"SUCCESS","opTime":"59 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-07-21 09:38:49 AUDIT audit:72 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338164483514027","opStatus":"START"}
2019-07-21 09:38:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-07-21 09:38:49 AUDIT audit:93 - {"time":"July 21, 2019 2:38:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20338164483514027","opStatus":"SUCCESS","opTime":"210 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
OK
******Total Number Of Rows Fetched ****** 0
- HiveExample *** FAILED ***
  java.lang.AssertionError: assertion failed
  at scala.Predef$.assert(Predef.scala:156)
  at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:171)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
  at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
  at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
  at org.scalatest.Transformer.apply(Transformer.scala:22)
  at org.scalatest.Transformer.apply(Transformer.scala:20)
  ...
Exception encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
          *** ABORTED ***
  java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
  at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)
  at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)
  at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)
  at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  ...
Run completed in 2 minutes, 36 seconds.
Total number of tests run: 21
Suites: completed 1, aborted 1
Tests: succeeded 20, failed 1, canceled 0, ignored 0, pending 0
*** 1 SUITE ABORTED ***
*** 1 TEST FAILED ***
[JENKINS] Recording test results

Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3648

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/3648/display/redirect>

------------------------------------------
[...truncated 278.57 KB...]
2019-07-20 09:42:08 AUDIT audit:93 - {"time":"July 20, 2019 2:42:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251963206741122","opStatus":"SUCCESS","opTime":"79 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-20 09:42:08 AUDIT audit:72 - {"time":"July 20, 2019 2:42:08 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20251963288680425","opStatus":"START"}
2019-07-20 09:42:09 AUDIT audit:93 - {"time":"July 20, 2019 2:42:09 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20251963288680425","opStatus":"SUCCESS","opTime":"555 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.45KB","IndexSize":"720.0B"}}
2019-07-20 09:42:09 AUDIT audit:72 - {"time":"July 20, 2019 2:42:09 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20251963854502073","opStatus":"START"}
2019-07-20 09:42:11 AUDIT audit:93 - {"time":"July 20, 2019 2:42:11 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20251963854502073","opStatus":"SUCCESS","opTime":"2815 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.295
time for query on table without lucene datamap table:0.191
+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good3|who and name6|
|which test1 good5|who and name5|
|which test1 good7|who and name3|
|which test1 good3|who and name6|
|which test1 good5|who and name5|
|which test1 good7|who and name3|
+-----------------+-------------+

+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good3|who and name6|
|which test1 good1|who and name6|
|which test1 good5|who and name5|
|which test1 good7|who and name3|
|which test1 good3|who and name6|
|which test1 good1|who and name6|
|which test1 good5|who and name5|
|which test1 good7|who and name3|
+-----------------+-------------+

2019-07-20 09:42:12 AUDIT audit:72 - {"time":"July 20, 2019 2:42:12 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20251967534319454","opStatus":"START"}
2019-07-20 09:42:12 AUDIT audit:93 - {"time":"July 20, 2019 2:42:12 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20251967534319454","opStatus":"SUCCESS","opTime":"115 ms","table":"default.persontable","extraInfo":{}}
- LuceneDataMapExample
2019-07-20 09:42:12 AUDIT audit:72 - {"time":"July 20, 2019 2:42:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251967663668087","opStatus":"START"}
2019-07-20 09:42:12 AUDIT audit:93 - {"time":"July 20, 2019 2:42:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251967663668087","opStatus":"SUCCESS","opTime":"64 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-20 09:42:12 AUDIT audit:72 - {"time":"July 20, 2019 2:42:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251967732095188","opStatus":"START"}
2019-07-20 09:42:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-20 09:42:13 AUDIT audit:93 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251967732095188","opStatus":"SUCCESS","opTime":"165 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-20 09:42:13 AUDIT audit:72 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251967902182600","opStatus":"START"}
2019-07-20 09:42:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-20 09:42:13 AUDIT audit:93 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251967902182600","opStatus":"SUCCESS","opTime":"141 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-20 09:42:13 AUDIT audit:72 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968047783155","opStatus":"START"}
2019-07-20 09:42:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-20 09:42:13 AUDIT audit:93 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968047783155","opStatus":"SUCCESS","opTime":"149 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-20 09:42:13 AUDIT audit:72 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968201799243","opStatus":"START"}
2019-07-20 09:42:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-20 09:42:13 AUDIT audit:93 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968201799243","opStatus":"SUCCESS","opTime":"157 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-20 09:42:13 AUDIT audit:72 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251968414825837","opStatus":"START"}
2019-07-20 09:42:13 AUDIT audit:93 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251968414825837","opStatus":"SUCCESS","opTime":"63 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-20 09:42:13 AUDIT audit:72 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968541122662","opStatus":"START"}
2019-07-20 09:42:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-20 09:42:13 AUDIT audit:93 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968541122662","opStatus":"SUCCESS","opTime":"166 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-20 09:42:13 AUDIT audit:72 - {"time":"July 20, 2019 2:42:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968713431234","opStatus":"START"}
2019-07-20 09:42:14 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-20 09:42:14 AUDIT audit:93 - {"time":"July 20, 2019 2:42:14 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251968713431234","opStatus":"SUCCESS","opTime":"196 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      60|
+--------+

2019-07-20 09:42:14 AUDIT audit:72 - {"time":"July 20, 2019 2:42:14 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20251968988446393","opStatus":"START"}
2019-07-20 09:42:14 AUDIT audit:93 - {"time":"July 20, 2019 2:42:14 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20251968988446393","opStatus":"SUCCESS","opTime":"175 ms","table":"default.origin_table","extraInfo":{}}
- ExternalTableExample

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	
- CarbonReaderExample
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|
+------+---+------+

- DirectSQLExample
2019-07-20 09:42:15 AUDIT audit:72 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251969796855730","opStatus":"START"}
2019-07-20 09:42:15 AUDIT audit:93 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251969796855730","opStatus":"SUCCESS","opTime":"89 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-20 09:42:15 AUDIT audit:72 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251969904883519","opStatus":"START"}
2019-07-20 09:42:15 AUDIT audit:93 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251969904883519","opStatus":"SUCCESS","opTime":"160 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-07-20 09:42:15 AUDIT audit:72 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251970073690345","opStatus":"START"}
2019-07-20 09:42:15 AUDIT audit:93 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251970073690345","opStatus":"SUCCESS","opTime":"148 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-07-20 09:42:15 AUDIT audit:72 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251970369310904","opStatus":"START"}
2019-07-20 09:42:15 AUDIT audit:93 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20251970369310904","opStatus":"SUCCESS","opTime":"81 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-07-20 09:42:15 AUDIT audit:72 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251970460302444","opStatus":"START"}
2019-07-20 09:42:15 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-07-20 09:42:15 AUDIT audit:93 - {"time":"July 20, 2019 2:42:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20251970460302444","opStatus":"SUCCESS","opTime":"233 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
OK
******Total Number Of Rows Fetched ****** 0
- HiveExample *** FAILED ***
  java.lang.AssertionError: assertion failed
  at scala.Predef$.assert(Predef.scala:156)
  at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:171)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
  at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
  at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
  at org.scalatest.Transformer.apply(Transformer.scala:22)
  at org.scalatest.Transformer.apply(Transformer.scala:20)
  ...
Exception encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
          *** ABORTED ***
  java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
  at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)
  at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)
  at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)
  at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  ...
Run completed in 2 minutes, 35 seconds.
Total number of tests run: 21
Suites: completed 1, aborted 1
Tests: succeeded 20, failed 1, canceled 0, ignored 0, pending 0
*** 1 SUITE ABORTED ***
*** 1 TEST FAILED ***
[JENKINS] Recording test results

Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3647

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/3647/display/redirect>

------------------------------------------
[...truncated 279.88 KB...]
|count(1)|
+--------+
|      10|
+--------+

+--------+
|count(1)|
+--------+
|      10|
+--------+

time for query on table with lucene datamap table:0.393
time for query on table without lucene datamap table:0.235
+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good3|who and name1|
|which test1 good9|who and name2|
|which test1 good9|who and name5|
|which test1 good5|who and name2|
|which test1 good0|who and name5|
|which test1 good3|who and name1|
|which test1 good9|who and name2|
|which test1 good9|who and name5|
|which test1 good5|who and name2|
|which test1 good0|who and name5|
+-----------------+-------------+

+-----------------+-------------+
|               id|         name|
+-----------------+-------------+
|which test1 good3|who and name1|
|which test1 good9|who and name2|
|which test1 good9|who and name5|
|which test1 good5|who and name2|
|which test1 good0|who and name5|
|which test1 good3|who and name1|
|which test1 good9|who and name2|
|which test1 good9|who and name5|
|which test1 good5|who and name2|
|which test1 good0|who and name5|
+-----------------+-------------+

2019-07-19 09:57:59 AUDIT audit:72 - {"time":"July 19, 2019 2:57:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"437652840616410","opStatus":"START"}
2019-07-19 09:57:59 AUDIT audit:93 - {"time":"July 19, 2019 2:57:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"437652840616410","opStatus":"SUCCESS","opTime":"166 ms","table":"default.persontable","extraInfo":{}}
- LuceneDataMapExample
2019-07-19 09:57:59 AUDIT audit:72 - {"time":"July 19, 2019 2:57:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437653023547605","opStatus":"START"}
2019-07-19 09:57:59 AUDIT audit:93 - {"time":"July 19, 2019 2:57:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437653023547605","opStatus":"SUCCESS","opTime":"71 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-19 09:57:59 AUDIT audit:72 - {"time":"July 19, 2019 2:57:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653100650528","opStatus":"START"}
2019-07-19 09:58:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-19 09:58:00 AUDIT audit:93 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653100650528","opStatus":"SUCCESS","opTime":"218 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-19 09:58:00 AUDIT audit:72 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653326610090","opStatus":"START"}
2019-07-19 09:58:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-19 09:58:00 AUDIT audit:93 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653326610090","opStatus":"SUCCESS","opTime":"208 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-19 09:58:00 AUDIT audit:72 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653541993748","opStatus":"START"}
2019-07-19 09:58:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-19 09:58:00 AUDIT audit:93 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653541993748","opStatus":"SUCCESS","opTime":"175 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-19 09:58:00 AUDIT audit:72 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653722473202","opStatus":"START"}
2019-07-19 09:58:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-19 09:58:00 AUDIT audit:93 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437653722473202","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-07-19 09:58:00 AUDIT audit:72 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437653983843053","opStatus":"START"}
2019-07-19 09:58:00 AUDIT audit:93 - {"time":"July 19, 2019 2:58:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437653983843053","opStatus":"SUCCESS","opTime":"85 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-07-19 09:58:01 AUDIT audit:72 - {"time":"July 19, 2019 2:58:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437654151656866","opStatus":"START"}
2019-07-19 09:58:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-19 09:58:01 AUDIT audit:93 - {"time":"July 19, 2019 2:58:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437654151656866","opStatus":"SUCCESS","opTime":"178 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-07-19 09:58:01 AUDIT audit:72 - {"time":"July 19, 2019 2:58:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437654335281631","opStatus":"START"}
2019-07-19 09:58:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-07-19 09:58:01 AUDIT audit:93 - {"time":"July 19, 2019 2:58:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437654335281631","opStatus":"SUCCESS","opTime":"171 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      60|
+--------+

2019-07-19 09:58:01 AUDIT audit:72 - {"time":"July 19, 2019 2:58:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"437654590331354","opStatus":"START"}
2019-07-19 09:58:01 AUDIT audit:93 - {"time":"July 19, 2019 2:58:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"437654590331354","opStatus":"SUCCESS","opTime":"176 ms","table":"default.origin_table","extraInfo":{}}
- ExternalTableExample

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	
- CarbonReaderExample
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|
+------+---+------+

- DirectSQLExample
2019-07-19 09:58:02 AUDIT audit:72 - {"time":"July 19, 2019 2:58:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437655546940949","opStatus":"START"}
2019-07-19 09:58:02 AUDIT audit:93 - {"time":"July 19, 2019 2:58:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437655546940949","opStatus":"SUCCESS","opTime":"106 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-07-19 09:58:02 AUDIT audit:72 - {"time":"July 19, 2019 2:58:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437655678292267","opStatus":"START"}
2019-07-19 09:58:02 AUDIT audit:93 - {"time":"July 19, 2019 2:58:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437655678292267","opStatus":"SUCCESS","opTime":"174 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-07-19 09:58:02 AUDIT audit:72 - {"time":"July 19, 2019 2:58:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437655862109312","opStatus":"START"}
2019-07-19 09:58:02 AUDIT audit:93 - {"time":"July 19, 2019 2:58:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437655862109312","opStatus":"SUCCESS","opTime":"152 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-07-19 09:58:02 AUDIT audit:72 - {"time":"July 19, 2019 2:58:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437656129563940","opStatus":"START"}
2019-07-19 09:58:03 AUDIT audit:93 - {"time":"July 19, 2019 2:58:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"437656129563940","opStatus":"SUCCESS","opTime":"73 ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-07-19 09:58:03 AUDIT audit:72 - {"time":"July 19, 2019 2:58:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437656210126450","opStatus":"START"}
2019-07-19 09:58:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table test_boundary
2019-07-19 09:58:03 AUDIT audit:93 - {"time":"July 19, 2019 2:58:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"437656210126450","opStatus":"SUCCESS","opTime":"216 ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
OK
******Total Number Of Rows Fetched ****** 0
- HiveExample *** FAILED ***
  java.lang.AssertionError: assertion failed
  at scala.Predef$.assert(Predef.scala:156)
  at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:171)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
  at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
  at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
  at org.scalatest.Transformer.apply(Transformer.scala:22)
  at org.scalatest.Transformer.apply(Transformer.scala:20)
  ...
Exception encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
          *** ABORTED ***
  java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)
org.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)
org.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
scala.collection.Iterator$class.foreach(Iterator.scala:893)
scala.collection.AbstractIterator.foreach(Iterator.scala:1336)
scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
scala.collection.AbstractIterable.foreach(Iterable.scala:54)
scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
scala.collection.AbstractTraversable.map(Traversable.scala:104)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)

The currently active SparkContext was created at:

(No active SparkContext.)
  at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)
  at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
  at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)
  at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)
  at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)
  at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)
  ...
Run completed in 3 minutes, 5 seconds.
Total number of tests run: 21
Suites: completed 1, aborted 1
Tests: succeeded 20, failed 1, canceled 0, ignored 0, pending 0
*** 1 SUITE ABORTED ***
*** 1 TEST FAILED ***
[JENKINS] Recording test results