You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2019/06/13 17:35:13 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3585
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3585/display/redirect>
------------------------------------------
[...truncated 277.75 KB...]
|29.575757575757574|2005-01-01 00:00:...|
|28.253164556962027|2014-01-01 00:00:...|
|29.226190476190474|2016-01-01 00:00:...|
|30.479674796747968|2015-01-01 00:00:...|
|29.936567164179106|2011-01-01 00:00:...|
|26.809352517985612|2009-01-01 00:00:...|
|29.191709844559586|2002-01-01 00:00:...|
|29.284444444444443|2004-01-01 00:00:...|
|27.509578544061302|2000-01-01 00:00:...|
|30.072519083969464|2008-01-01 00:00:...|
|30.945525291828794|2012-01-01 00:00:...|
|29.326848249027236|2007-01-01 00:00:...|
| 28.65289256198347|2013-01-01 00:00:...|
|30.049180327868854|2001-01-01 00:00:...|
+------------------+--------------------+
2019-06-13 17:34:00 AUDIT audit:72 - {"time":"June 13, 2019 10:34:00 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20141290542275269","opStatus":"START"}
2019-06-13 17:34:00 AUDIT audit:93 - {"time":"June 13, 2019 10:34:00 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20141290542275269","opStatus":"SUCCESS","opTime":"195 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-13 17:34:00 AUDIT audit:72 - {"time":"June 13, 2019 10:34:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141290829730616","opStatus":"START"}
2019-06-13 17:34:00 AUDIT audit:93 - {"time":"June 13, 2019 10:34:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141290829730616","opStatus":"SUCCESS","opTime":"52 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-13 17:34:00 AUDIT audit:72 - {"time":"June 13, 2019 10:34:00 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20141290883982326","opStatus":"START"}
2019-06-13 17:34:01 AUDIT audit:93 - {"time":"June 13, 2019 10:34:01 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20141290883982326","opStatus":"SUCCESS","opTime":"507 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.42KB","IndexSize":"720.0B"}}
2019-06-13 17:34:01 AUDIT audit:72 - {"time":"June 13, 2019 10:34:01 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20141291399472495","opStatus":"START"}
2019-06-13 17:34:03 AUDIT audit:93 - {"time":"June 13, 2019 10:34:03 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20141291399472495","opStatus":"SUCCESS","opTime":"1807 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.278
time for query on table without lucene datamap table:0.18
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name3|
|which test1 good8|who and name2|
|which test1 good9|who and name6|
|which test1 good2|who and name0|
|which test1 good8|who and name3|
|which test1 good8|who and name2|
|which test1 good9|who and name6|
|which test1 good2|who and name0|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name3|
|which test1 good8|who and name2|
|which test1 good9|who and name6|
|which test1 good2|who and name0|
|which test1 good8|who and name3|
|which test1 good8|who and name2|
|which test1 good9|who and name6|
|which test1 good2|who and name0|
+-----------------+-------------+
2019-06-13 17:34:04 AUDIT audit:72 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20141294081147000","opStatus":"START"}
2019-06-13 17:34:04 AUDIT audit:93 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20141294081147000","opStatus":"SUCCESS","opTime":"136 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-13 17:34:04 AUDIT audit:72 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141294239202851","opStatus":"START"}
2019-06-13 17:34:04 AUDIT audit:93 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141294239202851","opStatus":"SUCCESS","opTime":"73 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-13 17:34:04 AUDIT audit:72 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294323025852","opStatus":"START"}
2019-06-13 17:34:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-13 17:34:04 AUDIT audit:93 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294323025852","opStatus":"SUCCESS","opTime":"211 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-13 17:34:04 AUDIT audit:72 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294541042499","opStatus":"START"}
2019-06-13 17:34:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-13 17:34:04 AUDIT audit:93 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294541042499","opStatus":"SUCCESS","opTime":"179 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-13 17:34:04 AUDIT audit:72 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294725648859","opStatus":"START"}
2019-06-13 17:34:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-13 17:34:04 AUDIT audit:93 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294725648859","opStatus":"SUCCESS","opTime":"161 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-13 17:34:04 AUDIT audit:72 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294893130429","opStatus":"START"}
2019-06-13 17:34:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-13 17:34:04 AUDIT audit:93 - {"time":"June 13, 2019 10:34:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141294893130429","opStatus":"SUCCESS","opTime":"170 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-13 17:34:05 AUDIT audit:72 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141295132882109","opStatus":"START"}
2019-06-13 17:34:05 AUDIT audit:93 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141295132882109","opStatus":"SUCCESS","opTime":"57 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-13 17:34:05 AUDIT audit:72 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141295261030880","opStatus":"START"}
2019-06-13 17:34:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-13 17:34:05 AUDIT audit:93 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141295261030880","opStatus":"SUCCESS","opTime":"171 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-13 17:34:05 AUDIT audit:72 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141295438796822","opStatus":"START"}
2019-06-13 17:34:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-13 17:34:05 AUDIT audit:93 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141295438796822","opStatus":"SUCCESS","opTime":"207 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-13 17:34:05 AUDIT audit:72 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20141295714585222","opStatus":"START"}
2019-06-13 17:34:05 AUDIT audit:93 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20141295714585222","opStatus":"SUCCESS","opTime":"68 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-13 17:34:05 AUDIT audit:72 - {"time":"June 13, 2019 10:34:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141296061930008","opStatus":"START"}
2019-06-13 17:34:06 AUDIT audit:93 - {"time":"June 13, 2019 10:34:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20141296061930008","opStatus":"SUCCESS","opTime":"52 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-13 17:34:06 AUDIT audit:72 - {"time":"June 13, 2019 10:34:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141296130885540","opStatus":"START"}
2019-06-13 17:34:06 AUDIT audit:93 - {"time":"June 13, 2019 10:34:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141296130885540","opStatus":"SUCCESS","opTime":"171 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-13 17:34:06 AUDIT audit:72 - {"time":"June 13, 2019 10:34:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141296316780480","opStatus":"START"}
2019-06-13 17:34:06 AUDIT audit:93 - {"time":"June 13, 2019 10:34:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20141296316780480","opStatus":"SUCCESS","opTime":"182 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 6 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3595
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/3595/display/redirect>
------------------------------------------
[...truncated 277.85 KB...]
|29.392592592592592|2000-01-01 00:00:...|
| 27.79850746268657|2008-01-01 00:00:...|
| 28.18811881188119|2012-01-01 00:00:...|
| 29.30827067669173|2007-01-01 00:00:...|
|29.527272727272727|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-19 09:55:16 AUDIT audit:72 - {"time":"June 19, 2019 2:55:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5715069654975098","opStatus":"START"}
2019-06-19 09:55:16 AUDIT audit:93 - {"time":"June 19, 2019 2:55:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5715069654975098","opStatus":"SUCCESS","opTime":"297 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-19 09:55:16 AUDIT audit:72 - {"time":"June 19, 2019 2:55:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715070068278618","opStatus":"START"}
2019-06-19 09:55:17 AUDIT audit:93 - {"time":"June 19, 2019 2:55:17 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715070068278618","opStatus":"SUCCESS","opTime":"83 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-19 09:55:17 AUDIT audit:72 - {"time":"June 19, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5715070153821864","opStatus":"START"}
2019-06-19 09:55:17 AUDIT audit:93 - {"time":"June 19, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5715070153821864","opStatus":"SUCCESS","opTime":"633 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"770.94KB","IndexSize":"720.0B"}}
2019-06-19 09:55:17 AUDIT audit:72 - {"time":"June 19, 2019 2:55:17 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5715070792715387","opStatus":"START"}
2019-06-19 09:55:20 AUDIT audit:93 - {"time":"June 19, 2019 2:55:20 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5715070792715387","opStatus":"SUCCESS","opTime":"2442 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 16|
+--------+
+--------+
|count(1)|
+--------+
| 16|
+--------+
time for query on table with lucene datamap table:0.342
time for query on table without lucene datamap table:0.238
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good7|who and name6|
|which test1 good9|who and name1|
|which test1 good0|who and name0|
|which test1 good7|who and name7|
|which test1 good7|who and name5|
|which test1 good8|who and name3|
|which test1 good6|who and name1|
|which test1 good7|who and name6|
|which test1 good9|who and name1|
|which test1 good0|who and name0|
|which test1 good7|who and name7|
|which test1 good7|who and name5|
|which test1 good8|who and name3|
|which test1 good6|who and name1|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good1|who and name6|
|which test1 good7|who and name6|
|which test1 good9|who and name1|
|which test1 good0|who and name0|
|which test1 good7|who and name7|
|which test1 good7|who and name5|
|which test1 good8|who and name3|
|which test1 good6|who and name1|
|which test1 good1|who and name6|
|which test1 good7|who and name6|
+-----------------+-------------+
2019-06-19 09:55:21 AUDIT audit:72 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5715074180580061","opStatus":"START"}
2019-06-19 09:55:21 AUDIT audit:93 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5715074180580061","opStatus":"SUCCESS","opTime":"114 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-19 09:55:21 AUDIT audit:72 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715074317295871","opStatus":"START"}
2019-06-19 09:55:21 AUDIT audit:93 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715074317295871","opStatus":"SUCCESS","opTime":"94 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-19 09:55:21 AUDIT audit:72 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074418164750","opStatus":"START"}
2019-06-19 09:55:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:55:21 AUDIT audit:93 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074418164750","opStatus":"SUCCESS","opTime":"217 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:55:21 AUDIT audit:72 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074640699286","opStatus":"START"}
2019-06-19 09:55:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:55:21 AUDIT audit:93 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074640699286","opStatus":"SUCCESS","opTime":"157 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:55:21 AUDIT audit:72 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074802381309","opStatus":"START"}
2019-06-19 09:55:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:55:21 AUDIT audit:93 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074802381309","opStatus":"SUCCESS","opTime":"158 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:55:21 AUDIT audit:72 - {"time":"June 19, 2019 2:55:21 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074965794706","opStatus":"START"}
2019-06-19 09:55:21 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:55:22 AUDIT audit:93 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715074965794706","opStatus":"SUCCESS","opTime":"166 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-19 09:55:22 AUDIT audit:72 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715075204710931","opStatus":"START"}
2019-06-19 09:55:22 AUDIT audit:93 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715075204710931","opStatus":"SUCCESS","opTime":"77 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-19 09:55:22 AUDIT audit:72 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715075363516464","opStatus":"START"}
2019-06-19 09:55:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:55:22 AUDIT audit:93 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715075363516464","opStatus":"SUCCESS","opTime":"156 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:55:22 AUDIT audit:72 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715075524083000","opStatus":"START"}
2019-06-19 09:55:22 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:55:22 AUDIT audit:93 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715075524083000","opStatus":"SUCCESS","opTime":"170 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-19 09:55:22 AUDIT audit:72 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5715075771046845","opStatus":"START"}
2019-06-19 09:55:22 AUDIT audit:93 - {"time":"June 19, 2019 2:55:22 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5715075771046845","opStatus":"SUCCESS","opTime":"115 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-19 09:55:23 AUDIT audit:72 - {"time":"June 19, 2019 2:55:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715076194315433","opStatus":"START"}
2019-06-19 09:55:23 AUDIT audit:93 - {"time":"June 19, 2019 2:55:23 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5715076194315433","opStatus":"SUCCESS","opTime":"81 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-19 09:55:23 AUDIT audit:72 - {"time":"June 19, 2019 2:55:23 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715076292715312","opStatus":"START"}
2019-06-19 09:55:23 AUDIT audit:93 - {"time":"June 19, 2019 2:55:23 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715076292715312","opStatus":"SUCCESS","opTime":"198 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-19 09:55:23 AUDIT audit:72 - {"time":"June 19, 2019 2:55:23 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715076503775261","opStatus":"START"}
2019-06-19 09:55:23 AUDIT audit:93 - {"time":"June 19, 2019 2:55:23 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5715076503775261","opStatus":"SUCCESS","opTime":"173 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 57 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3594
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/3594/display/redirect>
------------------------------------------
[...truncated 279.01 KB...]
|29.714828897338403|2016-01-01 00:00:...|
| 29.39662447257384|2015-01-01 00:00:...|
|28.208510638297874|2011-01-01 00:00:...|
|29.419708029197082|2009-01-01 00:00:...|
|29.587755102040816|2002-01-01 00:00:...|
|28.091304347826085|2004-01-01 00:00:...|
| 31.20814479638009|2000-01-01 00:00:...|
| 29.33579335793358|2008-01-01 00:00:...|
| 29.77480916030534|2012-01-01 00:00:...|
|28.860759493670887|2007-01-01 00:00:...|
|29.633699633699635|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-19 09:41:07 AUDIT audit:72 - {"time":"June 19, 2019 2:41:07 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17573502601289982","opStatus":"START"}
2019-06-19 09:41:08 AUDIT audit:93 - {"time":"June 19, 2019 2:41:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17573502601289982","opStatus":"SUCCESS","opTime":"256 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-19 09:41:08 AUDIT audit:72 - {"time":"June 19, 2019 2:41:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573502953334625","opStatus":"START"}
2019-06-19 09:41:08 AUDIT audit:93 - {"time":"June 19, 2019 2:41:08 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573502953334625","opStatus":"SUCCESS","opTime":"77 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-19 09:41:08 AUDIT audit:72 - {"time":"June 19, 2019 2:41:08 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17573503032588463","opStatus":"START"}
2019-06-19 09:41:09 AUDIT audit:93 - {"time":"June 19, 2019 2:41:09 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17573503032588463","opStatus":"SUCCESS","opTime":"814 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"772.21KB","IndexSize":"720.0B"}}
2019-06-19 09:41:09 AUDIT audit:72 - {"time":"June 19, 2019 2:41:09 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17573503852528566","opStatus":"START"}
2019-06-19 09:41:11 AUDIT audit:93 - {"time":"June 19, 2019 2:41:11 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17573503852528566","opStatus":"SUCCESS","opTime":"2177 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 10|
+--------+
+--------+
|count(1)|
+--------+
| 10|
+--------+
time for query on table with lucene datamap table:0.247
time for query on table without lucene datamap table:0.182
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name4|
|which test1 good4|who and name7|
|which test1 good8|who and name7|
|which test1 good3|who and name2|
|which test1 good0|who and name4|
|which test1 good4|who and name7|
|which test1 good8|who and name7|
|which test1 good3|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name4|
|which test1 good4|who and name7|
|which test1 good8|who and name7|
|which test1 good1|who and name0|
|which test1 good3|who and name2|
|which test1 good0|who and name4|
|which test1 good4|who and name7|
|which test1 good8|who and name7|
|which test1 good1|who and name0|
|which test1 good3|who and name2|
+-----------------+-------------+
2019-06-19 09:41:12 AUDIT audit:72 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17573506794778302","opStatus":"START"}
2019-06-19 09:41:12 AUDIT audit:93 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17573506794778302","opStatus":"SUCCESS","opTime":"108 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-19 09:41:12 AUDIT audit:72 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573506920387759","opStatus":"START"}
2019-06-19 09:41:12 AUDIT audit:93 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573506920387759","opStatus":"SUCCESS","opTime":"67 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-19 09:41:12 AUDIT audit:72 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573506993599131","opStatus":"START"}
2019-06-19 09:41:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:41:12 AUDIT audit:93 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573506993599131","opStatus":"SUCCESS","opTime":"189 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:41:12 AUDIT audit:72 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507189003408","opStatus":"START"}
2019-06-19 09:41:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:41:12 AUDIT audit:93 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507189003408","opStatus":"SUCCESS","opTime":"161 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:41:12 AUDIT audit:72 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507356814997","opStatus":"START"}
2019-06-19 09:41:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:41:12 AUDIT audit:93 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507356814997","opStatus":"SUCCESS","opTime":"182 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:41:12 AUDIT audit:72 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507545020474","opStatus":"START"}
2019-06-19 09:41:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:41:12 AUDIT audit:93 - {"time":"June 19, 2019 2:41:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507545020474","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-19 09:41:13 AUDIT audit:72 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573507790723328","opStatus":"START"}
2019-06-19 09:41:13 AUDIT audit:93 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573507790723328","opStatus":"SUCCESS","opTime":"70 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-19 09:41:13 AUDIT audit:72 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507930423526","opStatus":"START"}
2019-06-19 09:41:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:41:13 AUDIT audit:93 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573507930423526","opStatus":"SUCCESS","opTime":"149 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-19 09:41:13 AUDIT audit:72 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573508084920986","opStatus":"START"}
2019-06-19 09:41:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-19 09:41:13 AUDIT audit:93 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573508084920986","opStatus":"SUCCESS","opTime":"177 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-19 09:41:13 AUDIT audit:72 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17573508351458830","opStatus":"START"}
2019-06-19 09:41:13 AUDIT audit:93 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17573508351458830","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
2019-06-19 09:41:13 AUDIT audit:72 - {"time":"June 19, 2019 2:41:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573508737795259","opStatus":"START"}
2019-06-19 09:41:14 AUDIT audit:93 - {"time":"June 19, 2019 2:41:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17573508737795259","opStatus":"SUCCESS","opTime":"75 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-19 09:41:14 AUDIT audit:72 - {"time":"June 19, 2019 2:41:14 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573508832149219","opStatus":"START"}
2019-06-19 09:41:14 AUDIT audit:93 - {"time":"June 19, 2019 2:41:14 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573508832149219","opStatus":"SUCCESS","opTime":"144 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-19 09:41:14 AUDIT audit:72 - {"time":"June 19, 2019 2:41:14 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573508986044194","opStatus":"START"}
2019-06-19 09:41:14 AUDIT audit:93 - {"time":"June 19, 2019 2:41:14 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17573508986044194","opStatus":"SUCCESS","opTime":"133 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 34 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3593
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/3593/display/redirect>
------------------------------------------
[...truncated 277.83 KB...]
| 29.79310344827586|2017-01-01 00:00:...|
| 29.07662835249042|2003-01-01 00:00:...|
|29.849206349206348|2005-01-01 00:00:...|
| 30.06756756756757|2014-01-01 00:00:...|
|29.016949152542374|2016-01-01 00:00:...|
|29.225563909774436|2015-01-01 00:00:...|
| 28.68663594470046|2011-01-01 00:00:...|
|32.279411764705884|2009-01-01 00:00:...|
| 28.98|2002-01-01 00:00:...|
| 28.51440329218107|2004-01-01 00:00:...|
|29.796992481203006|2000-01-01 00:00:...|
| 29.07509881422925|2008-01-01 00:00:...|
|30.135658914728683|2012-01-01 00:00:...|
|27.786259541984734|2007-01-01 00:00:...|
|29.887931034482758|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-18 09:50:30 AUDIT audit:72 - {"time":"June 18, 2019 2:50:30 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20612808050808435","opStatus":"START"}
2019-06-18 09:50:31 AUDIT audit:93 - {"time":"June 18, 2019 2:50:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20612808050808435","opStatus":"SUCCESS","opTime":"258 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-18 09:50:31 AUDIT audit:72 - {"time":"June 18, 2019 2:50:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612808435515775","opStatus":"START"}
2019-06-18 09:50:31 AUDIT audit:93 - {"time":"June 18, 2019 2:50:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612808435515775","opStatus":"SUCCESS","opTime":"98 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-18 09:50:31 AUDIT audit:72 - {"time":"June 18, 2019 2:50:31 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20612808535694777","opStatus":"START"}
2019-06-18 09:50:32 AUDIT audit:93 - {"time":"June 18, 2019 2:50:32 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20612808535694777","opStatus":"SUCCESS","opTime":"832 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"770.87KB","IndexSize":"720.0B"}}
2019-06-18 09:50:32 AUDIT audit:72 - {"time":"June 18, 2019 2:50:32 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20612809381401620","opStatus":"START"}
2019-06-18 09:50:34 AUDIT audit:93 - {"time":"June 18, 2019 2:50:34 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20612809381401620","opStatus":"SUCCESS","opTime":"2598 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.3
time for query on table without lucene datamap table:0.206
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name6|
|which test1 good2|who and name4|
|which test1 good2|who and name3|
|which test1 good2|who and name6|
|which test1 good2|who and name4|
|which test1 good2|who and name3|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name6|
|which test1 good2|who and name4|
|which test1 good2|who and name3|
|which test1 good1|who and name2|
|which test1 good2|who and name6|
|which test1 good2|who and name4|
|which test1 good2|who and name3|
|which test1 good1|who and name2|
+-----------------+-------------+
2019-06-18 09:50:35 AUDIT audit:72 - {"time":"June 18, 2019 2:50:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20612812917710424","opStatus":"START"}
2019-06-18 09:50:35 AUDIT audit:93 - {"time":"June 18, 2019 2:50:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20612812917710424","opStatus":"SUCCESS","opTime":"124 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-18 09:50:35 AUDIT audit:72 - {"time":"June 18, 2019 2:50:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612813060558118","opStatus":"START"}
2019-06-18 09:50:36 AUDIT audit:93 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612813060558118","opStatus":"SUCCESS","opTime":"71 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-18 09:50:36 AUDIT audit:72 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813138074157","opStatus":"START"}
2019-06-18 09:50:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 09:50:36 AUDIT audit:93 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813138074157","opStatus":"SUCCESS","opTime":"183 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 09:50:36 AUDIT audit:72 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813327061391","opStatus":"START"}
2019-06-18 09:50:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 09:50:36 AUDIT audit:93 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813327061391","opStatus":"SUCCESS","opTime":"163 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 09:50:36 AUDIT audit:72 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813494672156","opStatus":"START"}
2019-06-18 09:50:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 09:50:36 AUDIT audit:93 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813494672156","opStatus":"SUCCESS","opTime":"152 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 09:50:36 AUDIT audit:72 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813652419694","opStatus":"START"}
2019-06-18 09:50:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 09:50:36 AUDIT audit:93 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612813652419694","opStatus":"SUCCESS","opTime":"156 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-18 09:50:36 AUDIT audit:72 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612813867786949","opStatus":"START"}
2019-06-18 09:50:36 AUDIT audit:93 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612813867786949","opStatus":"SUCCESS","opTime":"56 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-18 09:50:36 AUDIT audit:72 - {"time":"June 18, 2019 2:50:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612814008131683","opStatus":"START"}
2019-06-18 09:50:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 09:50:37 AUDIT audit:93 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612814008131683","opStatus":"SUCCESS","opTime":"163 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 09:50:37 AUDIT audit:72 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612814177387078","opStatus":"START"}
2019-06-18 09:50:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 09:50:37 AUDIT audit:93 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612814177387078","opStatus":"SUCCESS","opTime":"158 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-18 09:50:37 AUDIT audit:72 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20612814401045025","opStatus":"START"}
2019-06-18 09:50:37 AUDIT audit:93 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20612814401045025","opStatus":"SUCCESS","opTime":"133 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-18 09:50:37 AUDIT audit:72 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612814832059573","opStatus":"START"}
2019-06-18 09:50:37 AUDIT audit:93 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20612814832059573","opStatus":"SUCCESS","opTime":"93 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-18 09:50:37 AUDIT audit:72 - {"time":"June 18, 2019 2:50:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612814943929053","opStatus":"START"}
2019-06-18 09:50:38 AUDIT audit:93 - {"time":"June 18, 2019 2:50:38 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612814943929053","opStatus":"SUCCESS","opTime":"177 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-18 09:50:38 AUDIT audit:72 - {"time":"June 18, 2019 2:50:38 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612815136811746","opStatus":"START"}
2019-06-18 09:50:38 AUDIT audit:93 - {"time":"June 18, 2019 2:50:38 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20612815136811746","opStatus":"SUCCESS","opTime":"170 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 55 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3592
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/3592/display/redirect>
------------------------------------------
[...truncated 278.23 KB...]
|29.555555555555557|2013-01-01 00:00:...|
| 29.92920353982301|2001-01-01 00:00:...|
+------------------+--------------------+
2019-06-18 07:33:15 AUDIT audit:72 - {"time":"June 18, 2019 12:33:15 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20530937936905291","opStatus":"START"}
2019-06-18 07:33:15 AUDIT audit:93 - {"time":"June 18, 2019 12:33:15 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20530937936905291","opStatus":"SUCCESS","opTime":"254 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-18 07:33:15 AUDIT audit:72 - {"time":"June 18, 2019 12:33:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530938313859252","opStatus":"START"}
2019-06-18 07:33:15 AUDIT audit:93 - {"time":"June 18, 2019 12:33:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530938313859252","opStatus":"SUCCESS","opTime":"80 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-18 07:33:15 AUDIT audit:72 - {"time":"June 18, 2019 12:33:15 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20530938396819231","opStatus":"START"}
2019-06-18 07:33:16 AUDIT audit:93 - {"time":"June 18, 2019 12:33:16 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20530938396819231","opStatus":"SUCCESS","opTime":"543 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"770.94KB","IndexSize":"720.0B"}}
2019-06-18 07:33:16 AUDIT audit:72 - {"time":"June 18, 2019 12:33:16 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20530938946059099","opStatus":"START"}
2019-06-18 07:33:17 AUDIT audit:93 - {"time":"June 18, 2019 12:33:17 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20530938946059099","opStatus":"SUCCESS","opTime":"1787 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 18|
+--------+
+--------+
|count(1)|
+--------+
| 18|
+--------+
time for query on table with lucene datamap table:0.25
time for query on table without lucene datamap table:0.158
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name0|
|which test1 good6|who and name4|
|which test1 good7|who and name6|
|which test1 good8|who and name6|
|which test1 good9|who and name0|
|which test1 good2|who and name7|
|which test1 good0|who and name7|
|which test1 good4|who and name0|
|which test1 good2|who and name4|
|which test1 good2|who and name0|
|which test1 good6|who and name4|
|which test1 good7|who and name6|
|which test1 good8|who and name6|
|which test1 good9|who and name0|
|which test1 good2|who and name7|
|which test1 good0|who and name7|
|which test1 good4|who and name0|
|which test1 good2|who and name4|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name0|
|which test1 good6|who and name4|
|which test1 good7|who and name6|
|which test1 good8|who and name6|
|which test1 good9|who and name0|
|which test1 good2|who and name7|
|which test1 good0|who and name7|
|which test1 good4|who and name0|
|which test1 good2|who and name4|
|which test1 good2|who and name0|
+-----------------+-------------+
2019-06-18 07:33:18 AUDIT audit:72 - {"time":"June 18, 2019 12:33:18 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20530941469580721","opStatus":"START"}
2019-06-18 07:33:18 AUDIT audit:93 - {"time":"June 18, 2019 12:33:18 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20530941469580721","opStatus":"SUCCESS","opTime":"104 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-18 07:33:18 AUDIT audit:72 - {"time":"June 18, 2019 12:33:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530941588529068","opStatus":"START"}
2019-06-18 07:33:18 AUDIT audit:93 - {"time":"June 18, 2019 12:33:18 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530941588529068","opStatus":"SUCCESS","opTime":"62 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-18 07:33:18 AUDIT audit:72 - {"time":"June 18, 2019 12:33:18 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530941656134773","opStatus":"START"}
2019-06-18 07:33:18 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 07:33:18 AUDIT audit:93 - {"time":"June 18, 2019 12:33:18 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530941656134773","opStatus":"SUCCESS","opTime":"170 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 07:33:18 AUDIT audit:72 - {"time":"June 18, 2019 12:33:18 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530941831729160","opStatus":"START"}
2019-06-18 07:33:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 07:33:19 AUDIT audit:93 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530941831729160","opStatus":"SUCCESS","opTime":"168 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 07:33:19 AUDIT audit:72 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942005621747","opStatus":"START"}
2019-06-18 07:33:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 07:33:19 AUDIT audit:93 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942005621747","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 07:33:19 AUDIT audit:72 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942183616410","opStatus":"START"}
2019-06-18 07:33:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 07:33:19 AUDIT audit:93 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942183616410","opStatus":"SUCCESS","opTime":"168 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-18 07:33:19 AUDIT audit:72 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530942419632383","opStatus":"START"}
2019-06-18 07:33:19 AUDIT audit:93 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530942419632383","opStatus":"SUCCESS","opTime":"56 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-18 07:33:19 AUDIT audit:72 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942549951790","opStatus":"START"}
2019-06-18 07:33:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 07:33:19 AUDIT audit:93 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942549951790","opStatus":"SUCCESS","opTime":"133 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-18 07:33:19 AUDIT audit:72 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942687093116","opStatus":"START"}
2019-06-18 07:33:19 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-18 07:33:19 AUDIT audit:93 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530942687093116","opStatus":"SUCCESS","opTime":"134 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-18 07:33:19 AUDIT audit:72 - {"time":"June 18, 2019 12:33:19 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20530942872811404","opStatus":"START"}
2019-06-18 07:33:20 AUDIT audit:93 - {"time":"June 18, 2019 12:33:20 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20530942872811404","opStatus":"SUCCESS","opTime":"81 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-18 07:33:20 AUDIT audit:72 - {"time":"June 18, 2019 12:33:20 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530943195747594","opStatus":"START"}
2019-06-18 07:33:20 AUDIT audit:93 - {"time":"June 18, 2019 12:33:20 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20530943195747594","opStatus":"SUCCESS","opTime":"72 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-18 07:33:20 AUDIT audit:72 - {"time":"June 18, 2019 12:33:20 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530943285801341","opStatus":"START"}
2019-06-18 07:33:20 AUDIT audit:93 - {"time":"June 18, 2019 12:33:20 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530943285801341","opStatus":"SUCCESS","opTime":"151 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-18 07:33:20 AUDIT audit:72 - {"time":"June 18, 2019 12:33:20 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530943445000584","opStatus":"START"}
2019-06-18 07:33:20 AUDIT audit:93 - {"time":"June 18, 2019 12:33:20 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20530943445000584","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|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 23 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3591
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/3591/display/redirect>
------------------------------------------
[...truncated 278.82 KB...]
| 30.63135593220339|2011-01-01 00:00:...|
|29.358565737051794|2009-01-01 00:00:...|
|28.759036144578314|2002-01-01 00:00:...|
| 29.744|2004-01-01 00:00:...|
| 29.5|2000-01-01 00:00:...|
| 30.33191489361702|2008-01-01 00:00:...|
|28.885375494071145|2012-01-01 00:00:...|
| 30.57831325301205|2007-01-01 00:00:...|
|29.032374100719423|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-17 18:09:46 AUDIT audit:72 - {"time":"June 17, 2019 11:09:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20786245194790433","opStatus":"START"}
2019-06-17 18:09:46 AUDIT audit:93 - {"time":"June 17, 2019 11:09:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20786245194790433","opStatus":"SUCCESS","opTime":"271 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-17 18:09:46 AUDIT audit:72 - {"time":"June 17, 2019 11:09:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786245557505903","opStatus":"START"}
2019-06-17 18:09:46 AUDIT audit:93 - {"time":"June 17, 2019 11:09:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786245557505903","opStatus":"SUCCESS","opTime":"72 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-17 18:09:46 AUDIT audit:72 - {"time":"June 17, 2019 11:09:46 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20786245631848371","opStatus":"START"}
2019-06-17 18:09:47 AUDIT audit:93 - {"time":"June 17, 2019 11:09:47 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20786245631848371","opStatus":"SUCCESS","opTime":"535 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.68KB","IndexSize":"720.0B"}}
2019-06-17 18:09:47 AUDIT audit:72 - {"time":"June 17, 2019 11:09:47 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20786246173581315","opStatus":"START"}
2019-06-17 18:09:49 AUDIT audit:93 - {"time":"June 17, 2019 11:09:49 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20786246173581315","opStatus":"SUCCESS","opTime":"2144 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 10|
+--------+
+--------+
|count(1)|
+--------+
| 10|
+--------+
time for query on table with lucene datamap table:0.256
time for query on table without lucene datamap table:0.177
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name0|
|which test1 good0|who and name5|
|which test1 good0|who and name2|
|which test1 good4|who and name1|
|which test1 good8|who and name5|
|which test1 good0|who and name0|
|which test1 good0|who and name5|
|which test1 good0|who and name2|
|which test1 good4|who and name1|
|which test1 good8|who and name5|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name0|
|which test1 good0|who and name5|
|which test1 good0|who and name2|
|which test1 good4|who and name1|
|which test1 good8|who and name5|
|which test1 good0|who and name0|
|which test1 good0|who and name5|
|which test1 good0|who and name2|
|which test1 good4|who and name1|
|which test1 good8|who and name5|
+-----------------+-------------+
2019-06-17 18:09:50 AUDIT audit:72 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20786249080977933","opStatus":"START"}
2019-06-17 18:09:50 AUDIT audit:93 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20786249080977933","opStatus":"SUCCESS","opTime":"99 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-17 18:09:50 AUDIT audit:72 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786249191762388","opStatus":"START"}
2019-06-17 18:09:50 AUDIT audit:93 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786249191762388","opStatus":"SUCCESS","opTime":"70 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-17 18:09:50 AUDIT audit:72 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249266419175","opStatus":"START"}
2019-06-17 18:09:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 18:09:50 AUDIT audit:93 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249266419175","opStatus":"SUCCESS","opTime":"157 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 18:09:50 AUDIT audit:72 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249428137779","opStatus":"START"}
2019-06-17 18:09:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 18:09:50 AUDIT audit:93 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249428137779","opStatus":"SUCCESS","opTime":"150 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 18:09:50 AUDIT audit:72 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249581916510","opStatus":"START"}
2019-06-17 18:09:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 18:09:50 AUDIT audit:93 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249581916510","opStatus":"SUCCESS","opTime":"137 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 18:09:50 AUDIT audit:72 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249726553073","opStatus":"START"}
2019-06-17 18:09:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 18:09:50 AUDIT audit:93 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786249726553073","opStatus":"SUCCESS","opTime":"146 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-17 18:09:50 AUDIT audit:72 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786249933485856","opStatus":"START"}
2019-06-17 18:09:50 AUDIT audit:93 - {"time":"June 17, 2019 11:09:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786249933485856","opStatus":"SUCCESS","opTime":"54 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-17 18:09:51 AUDIT audit:72 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786250057942436","opStatus":"START"}
2019-06-17 18:09:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 18:09:51 AUDIT audit:93 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786250057942436","opStatus":"SUCCESS","opTime":"142 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 18:09:51 AUDIT audit:72 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786250204521668","opStatus":"START"}
2019-06-17 18:09:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 18:09:51 AUDIT audit:93 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786250204521668","opStatus":"SUCCESS","opTime":"158 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-17 18:09:51 AUDIT audit:72 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20786250448621951","opStatus":"START"}
2019-06-17 18:09:51 AUDIT audit:93 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20786250448621951","opStatus":"SUCCESS","opTime":"114 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-17 18:09:51 AUDIT audit:72 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786250897698665","opStatus":"START"}
2019-06-17 18:09:51 AUDIT audit:93 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20786250897698665","opStatus":"SUCCESS","opTime":"81 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-17 18:09:51 AUDIT audit:72 - {"time":"June 17, 2019 11:09:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786250997553938","opStatus":"START"}
2019-06-17 18:09:52 AUDIT audit:93 - {"time":"June 17, 2019 11:09:52 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786250997553938","opStatus":"SUCCESS","opTime":"149 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-17 18:09:52 AUDIT audit:72 - {"time":"June 17, 2019 11:09:52 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786251157799400","opStatus":"START"}
2019-06-17 18:09:52 AUDIT audit:93 - {"time":"June 17, 2019 11:09:52 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20786251157799400","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|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 28 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3590
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/3590/display/redirect>
------------------------------------------
[...truncated 278.67 KB...]
| 30.58490566037736|2015-01-01 00:00:...|
| 32.3|2009-01-01 00:00:...|
| 28.92436974789916|2002-01-01 00:00:...|
|29.235494880546074|2004-01-01 00:00:...|
|30.875968992248062|2000-01-01 00:00:...|
| 29.62934362934363|2008-01-01 00:00:...|
|31.291666666666668|2012-01-01 00:00:...|
| 32.12987012987013|2007-01-01 00:00:...|
| 27.80072463768116|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-17 09:46:21 AUDIT audit:72 - {"time":"June 17, 2019 2:46:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20452528668239302","opStatus":"START"}
2019-06-17 09:46:21 AUDIT audit:93 - {"time":"June 17, 2019 2:46:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20452528668239302","opStatus":"SUCCESS","opTime":"198 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-17 09:46:21 AUDIT audit:72 - {"time":"June 17, 2019 2:46:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452528953723936","opStatus":"START"}
2019-06-17 09:46:21 AUDIT audit:93 - {"time":"June 17, 2019 2:46:21 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452528953723936","opStatus":"SUCCESS","opTime":"72 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-17 09:46:21 AUDIT audit:72 - {"time":"June 17, 2019 2:46:21 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20452529028683645","opStatus":"START"}
2019-06-17 09:46:22 AUDIT audit:93 - {"time":"June 17, 2019 2:46:22 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20452529028683645","opStatus":"SUCCESS","opTime":"413 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.44KB","IndexSize":"720.0B"}}
2019-06-17 09:46:22 AUDIT audit:72 - {"time":"June 17, 2019 2:46:22 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20452529445327788","opStatus":"START"}
2019-06-17 09:46:24 AUDIT audit:93 - {"time":"June 17, 2019 2:46:24 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20452529445327788","opStatus":"SUCCESS","opTime":"1910 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 10|
+--------+
+--------+
|count(1)|
+--------+
| 10|
+--------+
time for query on table with lucene datamap table:0.206
time for query on table without lucene datamap table:0.232
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good3|who and name5|
|which test1 good6|who and name6|
|which test1 good7|who and name3|
|which test1 good9|who and name6|
|which test1 good7|who and name4|
|which test1 good3|who and name5|
|which test1 good6|who and name6|
|which test1 good7|who and name3|
|which test1 good9|who and name6|
|which test1 good7|who and name4|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good3|who and name5|
|which test1 good6|who and name6|
|which test1 good7|who and name3|
|which test1 good9|who and name6|
|which test1 good7|who and name4|
|which test1 good3|who and name5|
|which test1 good6|who and name6|
|which test1 good7|who and name3|
|which test1 good9|who and name6|
|which test1 good7|who and name4|
+-----------------+-------------+
2019-06-17 09:46:25 AUDIT audit:72 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20452532075389622","opStatus":"START"}
2019-06-17 09:46:25 AUDIT audit:93 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20452532075389622","opStatus":"SUCCESS","opTime":"102 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-17 09:46:25 AUDIT audit:72 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452532195719781","opStatus":"START"}
2019-06-17 09:46:25 AUDIT audit:93 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452532195719781","opStatus":"SUCCESS","opTime":"65 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-17 09:46:25 AUDIT audit:72 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532269026905","opStatus":"START"}
2019-06-17 09:46:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 09:46:25 AUDIT audit:93 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532269026905","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 09:46:25 AUDIT audit:72 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532446451386","opStatus":"START"}
2019-06-17 09:46:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 09:46:25 AUDIT audit:93 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532446451386","opStatus":"SUCCESS","opTime":"162 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 09:46:25 AUDIT audit:72 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532616054248","opStatus":"START"}
2019-06-17 09:46:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 09:46:25 AUDIT audit:93 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532616054248","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 09:46:25 AUDIT audit:72 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532794667843","opStatus":"START"}
2019-06-17 09:46:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 09:46:25 AUDIT audit:93 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452532794667843","opStatus":"SUCCESS","opTime":"161 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-17 09:46:25 AUDIT audit:72 - {"time":"June 17, 2019 2:46:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452533040734003","opStatus":"START"}
2019-06-17 09:46:26 AUDIT audit:93 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452533040734003","opStatus":"SUCCESS","opTime":"61 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-17 09:46:26 AUDIT audit:72 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452533160755849","opStatus":"START"}
2019-06-17 09:46:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 09:46:26 AUDIT audit:93 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452533160755849","opStatus":"SUCCESS","opTime":"129 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-17 09:46:26 AUDIT audit:72 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452533293856509","opStatus":"START"}
2019-06-17 09:46:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-17 09:46:26 AUDIT audit:93 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452533293856509","opStatus":"SUCCESS","opTime":"136 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-17 09:46:26 AUDIT audit:72 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20452533487856378","opStatus":"START"}
2019-06-17 09:46:26 AUDIT audit:93 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20452533487856378","opStatus":"SUCCESS","opTime":"86 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-17 09:46:26 AUDIT audit:72 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452533817380771","opStatus":"START"}
2019-06-17 09:46:26 AUDIT audit:93 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20452533817380771","opStatus":"SUCCESS","opTime":"86 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-17 09:46:26 AUDIT audit:72 - {"time":"June 17, 2019 2:46:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452533926382550","opStatus":"START"}
2019-06-17 09:46:27 AUDIT audit:93 - {"time":"June 17, 2019 2:46:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452533926382550","opStatus":"SUCCESS","opTime":"159 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-17 09:46:27 AUDIT audit:72 - {"time":"June 17, 2019 2:46:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452534093096158","opStatus":"START"}
2019-06-17 09:46:27 AUDIT audit:93 - {"time":"June 17, 2019 2:46:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20452534093096158","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|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 26 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3589
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/3589/display/redirect>
------------------------------------------
[...truncated 277.78 KB...]
|29.048387096774192|2017-01-01 00:00:...|
|30.200854700854702|2003-01-01 00:00:...|
| 30.25409836065574|2005-01-01 00:00:...|
|29.356877323420075|2014-01-01 00:00:...|
|28.795744680851065|2016-01-01 00:00:...|
|30.884920634920636|2011-01-01 00:00:...|
|30.882113821138212|2015-01-01 00:00:...|
|29.569565217391304|2009-01-01 00:00:...|
| 29.19066147859922|2002-01-01 00:00:...|
|30.710743801652892|2004-01-01 00:00:...|
| 29.80708661417323|2000-01-01 00:00:...|
| 31.525|2008-01-01 00:00:...|
| 29.91860465116279|2012-01-01 00:00:...|
|31.047430830039527|2007-01-01 00:00:...|
|28.024489795918367|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-16 09:19:53 AUDIT audit:72 - {"time":"June 16, 2019 2:19:53 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20370843962220275","opStatus":"START"}
2019-06-16 09:19:54 AUDIT audit:93 - {"time":"June 16, 2019 2:19:54 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20370843962220275","opStatus":"SUCCESS","opTime":"162 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-16 09:19:54 AUDIT audit:72 - {"time":"June 16, 2019 2:19:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370844229542464","opStatus":"START"}
2019-06-16 09:19:54 AUDIT audit:93 - {"time":"June 16, 2019 2:19:54 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370844229542464","opStatus":"SUCCESS","opTime":"49 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-16 09:19:54 AUDIT audit:72 - {"time":"June 16, 2019 2:19:54 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20370844280842314","opStatus":"START"}
2019-06-16 09:19:54 AUDIT audit:93 - {"time":"June 16, 2019 2:19:54 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20370844280842314","opStatus":"SUCCESS","opTime":"510 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.22KB","IndexSize":"720.0B"}}
2019-06-16 09:19:54 AUDIT audit:72 - {"time":"June 16, 2019 2:19:54 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20370844797065294","opStatus":"START"}
2019-06-16 09:19:56 AUDIT audit:93 - {"time":"June 16, 2019 2:19:56 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20370844797065294","opStatus":"SUCCESS","opTime":"1926 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.217
time for query on table without lucene datamap table:0.165
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good9|who and name1|
|which test1 good7|who and name4|
|which test1 good2|who and name5|
|which test1 good9|who and name1|
|which test1 good7|who and name4|
|which test1 good2|who and name5|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good9|who and name1|
|which test1 good1|who and name0|
|which test1 good7|who and name4|
|which test1 good2|who and name5|
|which test1 good9|who and name1|
|which test1 good1|who and name0|
|which test1 good7|who and name4|
|which test1 good2|who and name5|
+-----------------+-------------+
2019-06-16 09:19:57 AUDIT audit:72 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20370847380614954","opStatus":"START"}
2019-06-16 09:19:57 AUDIT audit:93 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20370847380614954","opStatus":"SUCCESS","opTime":"61 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-16 09:19:57 AUDIT audit:72 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370847454063319","opStatus":"START"}
2019-06-16 09:19:57 AUDIT audit:93 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370847454063319","opStatus":"SUCCESS","opTime":"43 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-16 09:19:57 AUDIT audit:72 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370847500660829","opStatus":"START"}
2019-06-16 09:19:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-16 09:19:57 AUDIT audit:93 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370847500660829","opStatus":"SUCCESS","opTime":"183 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-16 09:19:57 AUDIT audit:72 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370847689211769","opStatus":"START"}
2019-06-16 09:19:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-16 09:19:57 AUDIT audit:93 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370847689211769","opStatus":"SUCCESS","opTime":"166 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-16 09:19:57 AUDIT audit:72 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370847860824459","opStatus":"START"}
2019-06-16 09:19:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-16 09:19:57 AUDIT audit:93 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370847860824459","opStatus":"SUCCESS","opTime":"151 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-16 09:19:57 AUDIT audit:72 - {"time":"June 16, 2019 2:19:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370848016580625","opStatus":"START"}
2019-06-16 09:19:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-16 09:19:58 AUDIT audit:93 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370848016580625","opStatus":"SUCCESS","opTime":"187 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-16 09:19:58 AUDIT audit:72 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370848267534847","opStatus":"START"}
2019-06-16 09:19:58 AUDIT audit:93 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370848267534847","opStatus":"SUCCESS","opTime":"45 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-16 09:19:58 AUDIT audit:72 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370848382515886","opStatus":"START"}
2019-06-16 09:19:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-16 09:19:58 AUDIT audit:93 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370848382515886","opStatus":"SUCCESS","opTime":"160 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-16 09:19:58 AUDIT audit:72 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370848548531589","opStatus":"START"}
2019-06-16 09:19:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-16 09:19:58 AUDIT audit:93 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370848548531589","opStatus":"SUCCESS","opTime":"179 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-16 09:19:58 AUDIT audit:72 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20370848791639325","opStatus":"START"}
2019-06-16 09:19:58 AUDIT audit:93 - {"time":"June 16, 2019 2:19:58 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20370848791639325","opStatus":"SUCCESS","opTime":"65 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-16 09:19:59 AUDIT audit:72 - {"time":"June 16, 2019 2:19:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370849090743716","opStatus":"START"}
2019-06-16 09:19:59 AUDIT audit:93 - {"time":"June 16, 2019 2:19:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20370849090743716","opStatus":"SUCCESS","opTime":"52 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-16 09:19:59 AUDIT audit:72 - {"time":"June 16, 2019 2:19:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370849160669363","opStatus":"START"}
2019-06-16 09:19:59 AUDIT audit:93 - {"time":"June 16, 2019 2:19:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370849160669363","opStatus":"SUCCESS","opTime":"173 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-16 09:19:59 AUDIT audit:72 - {"time":"June 16, 2019 2:19:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370849344175687","opStatus":"START"}
2019-06-16 09:19:59 AUDIT audit:93 - {"time":"June 16, 2019 2:19:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20370849344175687","opStatus":"SUCCESS","opTime":"159 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 1 minute, 55 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3588
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/3588/display/redirect>
------------------------------------------
[...truncated 277.22 KB...]
+------------------+--------------------+
|30.972549019607843|2019-01-01 00:00:...|
|28.098425196850393|2006-01-01 00:00:...|
|28.598540145985403|2010-01-01 00:00:...|
| 42.0| null|
|27.456692913385826|2018-01-01 00:00:...|
| 30.18359375|2017-01-01 00:00:...|
|30.656521739130437|2003-01-01 00:00:...|
|30.053719008264462|2005-01-01 00:00:...|
|29.262172284644194|2014-01-01 00:00:...|
|28.498168498168496|2016-01-01 00:00:...|
|29.696153846153845|2015-01-01 00:00:...|
|30.647058823529413|2011-01-01 00:00:...|
| 28.45816733067729|2009-01-01 00:00:...|
| 29.99579831932773|2002-01-01 00:00:...|
| 32.44588744588744|2004-01-01 00:00:...|
|31.841666666666665|2000-01-01 00:00:...|
| 27.47747747747748|2008-01-01 00:00:...|
|28.435344827586206|2012-01-01 00:00:...|
| 28.5390625|2007-01-01 00:00:...|
| 29.62962962962963|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-15 09:44:54 AUDIT audit:72 - {"time":"June 15, 2019 2:44:54 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5368848073696519","opStatus":"START"}
2019-06-15 09:44:55 AUDIT audit:93 - {"time":"June 15, 2019 2:44:55 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5368848073696519","opStatus":"SUCCESS","opTime":"297 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-15 09:44:55 AUDIT audit:72 - {"time":"June 15, 2019 2:44:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368848479893338","opStatus":"START"}
2019-06-15 09:44:55 AUDIT audit:93 - {"time":"June 15, 2019 2:44:55 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368848479893338","opStatus":"SUCCESS","opTime":"99 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-15 09:44:55 AUDIT audit:72 - {"time":"June 15, 2019 2:44:55 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5368848582343055","opStatus":"START"}
2019-06-15 09:44:56 AUDIT audit:93 - {"time":"June 15, 2019 2:44:56 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5368848582343055","opStatus":"SUCCESS","opTime":"805 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.18KB","IndexSize":"720.0B"}}
2019-06-15 09:44:56 AUDIT audit:72 - {"time":"June 15, 2019 2:44:56 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5368849396296566","opStatus":"START"}
2019-06-15 09:44:58 AUDIT audit:93 - {"time":"June 15, 2019 2:44:58 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5368849396296566","opStatus":"SUCCESS","opTime":"2326 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 4|
+--------+
+--------+
|count(1)|
+--------+
| 4|
+--------+
time for query on table with lucene datamap table:0.314
time for query on table without lucene datamap table:0.255
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good9|who and name6|
|which test1 good6|who and name7|
|which test1 good9|who and name6|
|which test1 good6|who and name7|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good9|who and name6|
|which test1 good6|who and name7|
|which test1 good9|who and name6|
|which test1 good6|who and name7|
+-----------------+-------------+
2019-06-15 09:44:59 AUDIT audit:72 - {"time":"June 15, 2019 2:44:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5368852675586770","opStatus":"START"}
2019-06-15 09:44:59 AUDIT audit:93 - {"time":"June 15, 2019 2:44:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5368852675586770","opStatus":"SUCCESS","opTime":"92 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-15 09:44:59 AUDIT audit:72 - {"time":"June 15, 2019 2:44:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368852784383000","opStatus":"START"}
2019-06-15 09:44:59 AUDIT audit:93 - {"time":"June 15, 2019 2:44:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368852784383000","opStatus":"SUCCESS","opTime":"60 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-15 09:44:59 AUDIT audit:72 - {"time":"June 15, 2019 2:44:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368852848908890","opStatus":"START"}
2019-06-15 09:44:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-15 09:44:59 AUDIT audit:93 - {"time":"June 15, 2019 2:44:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368852848908890","opStatus":"SUCCESS","opTime":"185 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-15 09:44:59 AUDIT audit:72 - {"time":"June 15, 2019 2:44:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853040946219","opStatus":"START"}
2019-06-15 09:45:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-15 09:45:00 AUDIT audit:93 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853040946219","opStatus":"SUCCESS","opTime":"171 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-15 09:45:00 AUDIT audit:72 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853218475303","opStatus":"START"}
2019-06-15 09:45:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-15 09:45:00 AUDIT audit:93 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853218475303","opStatus":"SUCCESS","opTime":"165 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-15 09:45:00 AUDIT audit:72 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853388928652","opStatus":"START"}
2019-06-15 09:45:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-15 09:45:00 AUDIT audit:93 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853388928652","opStatus":"SUCCESS","opTime":"199 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-15 09:45:00 AUDIT audit:72 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368853666139195","opStatus":"START"}
2019-06-15 09:45:00 AUDIT audit:93 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368853666139195","opStatus":"SUCCESS","opTime":"63 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-15 09:45:00 AUDIT audit:72 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853796552939","opStatus":"START"}
2019-06-15 09:45:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-15 09:45:00 AUDIT audit:93 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853796552939","opStatus":"SUCCESS","opTime":"155 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-15 09:45:00 AUDIT audit:72 - {"time":"June 15, 2019 2:45:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853961532233","opStatus":"START"}
2019-06-15 09:45:00 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-15 09:45:01 AUDIT audit:93 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368853961532233","opStatus":"SUCCESS","opTime":"176 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-15 09:45:01 AUDIT audit:72 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5368854219608947","opStatus":"START"}
2019-06-15 09:45:01 AUDIT audit:93 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5368854219608947","opStatus":"SUCCESS","opTime":"126 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-15 09:45:01 AUDIT audit:72 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368854676479630","opStatus":"START"}
2019-06-15 09:45:01 AUDIT audit:93 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5368854676479630","opStatus":"SUCCESS","opTime":"93 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-15 09:45:01 AUDIT audit:72 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368854795535542","opStatus":"START"}
2019-06-15 09:45:01 AUDIT audit:93 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368854795535542","opStatus":"SUCCESS","opTime":"172 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-15 09:45:01 AUDIT audit:72 - {"time":"June 15, 2019 2:45:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368854979955065","opStatus":"START"}
2019-06-15 09:45:02 AUDIT audit:93 - {"time":"June 15, 2019 2:45:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5368854979955065","opStatus":"SUCCESS","opTime":"170 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 57 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3587
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/3587/display/redirect>
------------------------------------------
[...truncated 278.33 KB...]
| 29.08|2015-01-01 00:00:...|
|28.804347826086957|2009-01-01 00:00:...|
|29.938931297709924|2002-01-01 00:00:...|
|31.622489959839356|2004-01-01 00:00:...|
| 31.25390625|2000-01-01 00:00:...|
|29.867768595041323|2008-01-01 00:00:...|
|29.070866141732285|2012-01-01 00:00:...|
| 29.25287356321839|2007-01-01 00:00:...|
| 28.20912547528517|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-14 12:13:01 AUDIT audit:72 - {"time":"June 14, 2019 5:13:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20208431646273378","opStatus":"START"}
2019-06-14 12:13:01 AUDIT audit:93 - {"time":"June 14, 2019 5:13:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20208431646273378","opStatus":"SUCCESS","opTime":"222 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-14 12:13:01 AUDIT audit:72 - {"time":"June 14, 2019 5:13:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208431971770094","opStatus":"START"}
2019-06-14 12:13:01 AUDIT audit:93 - {"time":"June 14, 2019 5:13:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208431971770094","opStatus":"SUCCESS","opTime":"65 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-14 12:13:01 AUDIT audit:72 - {"time":"June 14, 2019 5:13:01 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20208432039590412","opStatus":"START"}
2019-06-14 12:13:02 AUDIT audit:93 - {"time":"June 14, 2019 5:13:02 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20208432039590412","opStatus":"SUCCESS","opTime":"561 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"770.98KB","IndexSize":"720.0B"}}
2019-06-14 12:13:02 AUDIT audit:72 - {"time":"June 14, 2019 5:13:02 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20208432607422649","opStatus":"START"}
2019-06-14 12:13:04 AUDIT audit:93 - {"time":"June 14, 2019 5:13:04 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20208432607422649","opStatus":"SUCCESS","opTime":"1943 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 12|
+--------+
+--------+
|count(1)|
+--------+
| 12|
+--------+
time for query on table with lucene datamap table:0.348
time for query on table without lucene datamap table:0.204
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good3|who and name7|
|which test1 good0|who and name5|
|which test1 good8|who and name6|
|which test1 good0|who and name0|
|which test1 good9|who and name4|
|which test1 good3|who and name7|
|which test1 good0|who and name5|
|which test1 good8|who and name6|
|which test1 good0|who and name0|
|which test1 good9|who and name4|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good3|who and name7|
|which test1 good0|who and name5|
|which test1 good8|who and name6|
|which test1 good0|who and name0|
|which test1 good1|who and name3|
|which test1 good9|who and name4|
|which test1 good3|who and name7|
|which test1 good0|who and name5|
|which test1 good8|who and name6|
|which test1 good0|who and name0|
+-----------------+-------------+
2019-06-14 12:13:05 AUDIT audit:72 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20208435489356513","opStatus":"START"}
2019-06-14 12:13:05 AUDIT audit:93 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20208435489356513","opStatus":"SUCCESS","opTime":"86 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-14 12:13:05 AUDIT audit:72 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208435594059842","opStatus":"START"}
2019-06-14 12:13:05 AUDIT audit:93 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208435594059842","opStatus":"SUCCESS","opTime":"64 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-14 12:13:05 AUDIT audit:72 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208435663861496","opStatus":"START"}
2019-06-14 12:13:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 12:13:05 AUDIT audit:93 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208435663861496","opStatus":"SUCCESS","opTime":"174 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 12:13:05 AUDIT audit:72 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208435843655312","opStatus":"START"}
2019-06-14 12:13:05 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 12:13:05 AUDIT audit:93 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208435843655312","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 12:13:05 AUDIT audit:72 - {"time":"June 14, 2019 5:13:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436021714354","opStatus":"START"}
2019-06-14 12:13:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 12:13:06 AUDIT audit:93 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436021714354","opStatus":"SUCCESS","opTime":"177 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 12:13:06 AUDIT audit:72 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436206087659","opStatus":"START"}
2019-06-14 12:13:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 12:13:06 AUDIT audit:93 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436206087659","opStatus":"SUCCESS","opTime":"181 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-14 12:13:06 AUDIT audit:72 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208436459106537","opStatus":"START"}
2019-06-14 12:13:06 AUDIT audit:93 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208436459106537","opStatus":"SUCCESS","opTime":"60 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-14 12:13:06 AUDIT audit:72 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436594206915","opStatus":"START"}
2019-06-14 12:13:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 12:13:06 AUDIT audit:93 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436594206915","opStatus":"SUCCESS","opTime":"154 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 12:13:06 AUDIT audit:72 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436754880264","opStatus":"START"}
2019-06-14 12:13:06 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 12:13:06 AUDIT audit:93 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208436754880264","opStatus":"SUCCESS","opTime":"168 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-14 12:13:06 AUDIT audit:72 - {"time":"June 14, 2019 5:13:06 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20208436993689630","opStatus":"START"}
2019-06-14 12:13:07 AUDIT audit:93 - {"time":"June 14, 2019 5:13:07 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20208436993689630","opStatus":"SUCCESS","opTime":"86 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-14 12:13:07 AUDIT audit:72 - {"time":"June 14, 2019 5:13:07 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208437348589290","opStatus":"START"}
2019-06-14 12:13:07 AUDIT audit:93 - {"time":"June 14, 2019 5:13:07 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20208437348589290","opStatus":"SUCCESS","opTime":"67 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-14 12:13:07 AUDIT audit:72 - {"time":"June 14, 2019 5:13:07 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208437433800754","opStatus":"START"}
2019-06-14 12:13:07 AUDIT audit:93 - {"time":"June 14, 2019 5:13:07 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208437433800754","opStatus":"SUCCESS","opTime":"146 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-14 12:13:07 AUDIT audit:72 - {"time":"June 14, 2019 5:13:07 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208437592942275","opStatus":"START"}
2019-06-14 12:13:07 AUDIT audit:93 - {"time":"June 14, 2019 5:13:07 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20208437592942275","opStatus":"SUCCESS","opTime":"143 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 7 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3586
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/3586/display/redirect>
------------------------------------------
[...truncated 277.26 KB...]
only showing top 20 rows
+------------------+--------------------+
| avg(age)| UDF(mytime, year)|
+------------------+--------------------+
|29.295019157088124|2019-01-01 00:00:...|
| 29.16370106761566|2006-01-01 00:00:...|
| 28.90983606557377|2010-01-01 00:00:...|
| 49.5| null|
|31.429223744292237|2018-01-01 00:00:...|
|29.084444444444443|2017-01-01 00:00:...|
| 29.55294117647059|2003-01-01 00:00:...|
|29.839080459770116|2005-01-01 00:00:...|
|27.753846153846155|2014-01-01 00:00:...|
|30.459349593495936|2016-01-01 00:00:...|
|30.036290322580644|2015-01-01 00:00:...|
|29.713043478260868|2011-01-01 00:00:...|
| 28.15695067264574|2009-01-01 00:00:...|
|28.650602409638555|2002-01-01 00:00:...|
| 28.83400809716599|2004-01-01 00:00:...|
|28.453846153846154|2000-01-01 00:00:...|
| 27.67063492063492|2008-01-01 00:00:...|
|30.643939393939394|2012-01-01 00:00:...|
| 29.45275590551181|2007-01-01 00:00:...|
|29.066420664206642|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-14 09:55:09 AUDIT audit:72 - {"time":"June 14, 2019 2:55:09 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20193857031711013","opStatus":"START"}
2019-06-14 09:55:10 AUDIT audit:93 - {"time":"June 14, 2019 2:55:10 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20193857031711013","opStatus":"SUCCESS","opTime":"291 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-14 09:55:10 AUDIT audit:72 - {"time":"June 14, 2019 2:55:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193857435004931","opStatus":"START"}
2019-06-14 09:55:10 AUDIT audit:93 - {"time":"June 14, 2019 2:55:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193857435004931","opStatus":"SUCCESS","opTime":"85 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-14 09:55:10 AUDIT audit:72 - {"time":"June 14, 2019 2:55:10 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20193857522138483","opStatus":"START"}
2019-06-14 09:55:11 AUDIT audit:93 - {"time":"June 14, 2019 2:55:11 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"20193857522138483","opStatus":"SUCCESS","opTime":"839 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.44KB","IndexSize":"720.0B"}}
2019-06-14 09:55:11 AUDIT audit:72 - {"time":"June 14, 2019 2:55:11 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20193858371097923","opStatus":"START"}
2019-06-14 09:55:13 AUDIT audit:93 - {"time":"June 14, 2019 2:55:13 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"20193858371097923","opStatus":"SUCCESS","opTime":"2350 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 2|
+--------+
+--------+
|count(1)|
+--------+
| 2|
+--------+
time for query on table with lucene datamap table:0.329
time for query on table without lucene datamap table:0.225
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name0|
|which test1 good8|who and name0|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name0|
|which test1 good8|who and name0|
+-----------------+-------------+
2019-06-14 09:55:14 AUDIT audit:72 - {"time":"June 14, 2019 2:55:14 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20193861684835178","opStatus":"START"}
2019-06-14 09:55:14 AUDIT audit:93 - {"time":"June 14, 2019 2:55:14 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20193861684835178","opStatus":"SUCCESS","opTime":"122 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-14 09:55:14 AUDIT audit:72 - {"time":"June 14, 2019 2:55:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193861825103685","opStatus":"START"}
2019-06-14 09:55:14 AUDIT audit:93 - {"time":"June 14, 2019 2:55:14 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193861825103685","opStatus":"SUCCESS","opTime":"69 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-14 09:55:14 AUDIT audit:72 - {"time":"June 14, 2019 2:55:14 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193861902823022","opStatus":"START"}
2019-06-14 09:55:14 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 09:55:15 AUDIT audit:93 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193861902823022","opStatus":"SUCCESS","opTime":"184 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 09:55:15 AUDIT audit:72 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862094632563","opStatus":"START"}
2019-06-14 09:55:15 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 09:55:15 AUDIT audit:93 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862094632563","opStatus":"SUCCESS","opTime":"174 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 09:55:15 AUDIT audit:72 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862274826157","opStatus":"START"}
2019-06-14 09:55:15 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 09:55:15 AUDIT audit:93 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862274826157","opStatus":"SUCCESS","opTime":"164 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 09:55:15 AUDIT audit:72 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862444945377","opStatus":"START"}
2019-06-14 09:55:15 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 09:55:15 AUDIT audit:93 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862444945377","opStatus":"SUCCESS","opTime":"189 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-14 09:55:15 AUDIT audit:72 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193862744820155","opStatus":"START"}
2019-06-14 09:55:15 AUDIT audit:93 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193862744820155","opStatus":"SUCCESS","opTime":"66 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-14 09:55:15 AUDIT audit:72 - {"time":"June 14, 2019 2:55:15 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862889144368","opStatus":"START"}
2019-06-14 09:55:15 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 09:55:16 AUDIT audit:93 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193862889144368","opStatus":"SUCCESS","opTime":"165 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-14 09:55:16 AUDIT audit:72 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193863059819309","opStatus":"START"}
2019-06-14 09:55:16 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-14 09:55:16 AUDIT audit:93 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193863059819309","opStatus":"SUCCESS","opTime":"180 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-14 09:55:16 AUDIT audit:72 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20193863299835194","opStatus":"START"}
2019-06-14 09:55:16 AUDIT audit:93 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"20193863299835194","opStatus":"SUCCESS","opTime":"105 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-14 09:55:16 AUDIT audit:72 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193863871649214","opStatus":"START"}
2019-06-14 09:55:16 AUDIT audit:93 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"20193863871649214","opStatus":"SUCCESS","opTime":"130 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-14 09:55:16 AUDIT audit:72 - {"time":"June 14, 2019 2:55:16 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193864020624975","opStatus":"START"}
2019-06-14 09:55:17 AUDIT audit:93 - {"time":"June 14, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193864020624975","opStatus":"SUCCESS","opTime":"162 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-14 09:55:17 AUDIT audit:72 - {"time":"June 14, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193864201682679","opStatus":"START"}
2019-06-14 09:55:17 AUDIT audit:93 - {"time":"June 14, 2019 2:55:17 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"20193864201682679","opStatus":"SUCCESS","opTime":"172 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 35 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results