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/05/28 16:51:19 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3549
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3549/display/redirect>
------------------------------------------
[...truncated 278.13 KB...]
| 29.7890625|2011-01-01 00:00:...|
| 30.20703125|2009-01-01 00:00:...|
|28.415384615384614|2002-01-01 00:00:...|
| 30.00862068965517|2004-01-01 00:00:...|
|29.231833910034602|2000-01-01 00:00:...|
|29.463709677419356|2008-01-01 00:00:...|
| 28.84351145038168|2012-01-01 00:00:...|
|28.677966101694917|2007-01-01 00:00:...|
|30.522088353413654|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-05-28 16:50:05 AUDIT audit:72 - {"time":"May 28, 2019 9:50:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18756256031292119","opStatus":"START"}
2019-05-28 16:50:06 AUDIT audit:93 - {"time":"May 28, 2019 9:50:06 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18756256031292119","opStatus":"SUCCESS","opTime":"308 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-05-28 16:50:06 AUDIT audit:72 - {"time":"May 28, 2019 9:50:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756256450241057","opStatus":"START"}
2019-05-28 16:50:06 AUDIT audit:93 - {"time":"May 28, 2019 9:50:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756256450241057","opStatus":"SUCCESS","opTime":"56 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-28 16:50:06 AUDIT audit:72 - {"time":"May 28, 2019 9:50:06 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18756256508761173","opStatus":"START"}
2019-05-28 16:50:07 AUDIT audit:93 - {"time":"May 28, 2019 9:50:07 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18756256508761173","opStatus":"SUCCESS","opTime":"704 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.92KB","IndexSize":"720.0B"}}
2019-05-28 16:50:07 AUDIT audit:72 - {"time":"May 28, 2019 9:50:07 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18756257219311402","opStatus":"START"}
2019-05-28 16:50:08 AUDIT audit:93 - {"time":"May 28, 2019 9:50:08 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18756257219311402","opStatus":"SUCCESS","opTime":"1714 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.311
time for query on table without lucene datamap table:0.176
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good7|who and name1|
|which test1 good4|who and name0|
|which test1 good8|who and name7|
|which test1 good5|who and name2|
|which test1 good3|who and name0|
|which test1 good7|who and name1|
|which test1 good4|who and name0|
|which test1 good8|who and name7|
|which test1 good5|who and name2|
|which test1 good3|who and name0|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good7|who and name1|
|which test1 good4|who and name0|
|which test1 good8|who and name7|
|which test1 good5|who and name2|
|which test1 good3|who and name0|
|which test1 good7|who and name1|
|which test1 good4|who and name0|
|which test1 good8|who and name7|
|which test1 good5|who and name2|
|which test1 good3|who and name0|
+-----------------+-------------+
2019-05-28 16:50:09 AUDIT audit:72 - {"time":"May 28, 2019 9:50:09 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18756259840148152","opStatus":"START"}
2019-05-28 16:50:09 AUDIT audit:93 - {"time":"May 28, 2019 9:50:09 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18756259840148152","opStatus":"SUCCESS","opTime":"116 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-05-28 16:50:09 AUDIT audit:72 - {"time":"May 28, 2019 9:50:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756259971425598","opStatus":"START"}
2019-05-28 16:50:10 AUDIT audit:93 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756259971425598","opStatus":"SUCCESS","opTime":"100 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-28 16:50:10 AUDIT audit:72 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260082592275","opStatus":"START"}
2019-05-28 16:50:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-28 16:50:10 AUDIT audit:93 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260082592275","opStatus":"SUCCESS","opTime":"214 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-28 16:50:10 AUDIT audit:72 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260301527241","opStatus":"START"}
2019-05-28 16:50:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-28 16:50:10 AUDIT audit:93 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260301527241","opStatus":"SUCCESS","opTime":"209 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-28 16:50:10 AUDIT audit:72 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260515244030","opStatus":"START"}
2019-05-28 16:50:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-28 16:50:10 AUDIT audit:93 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260515244030","opStatus":"SUCCESS","opTime":"219 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-28 16:50:10 AUDIT audit:72 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260739249883","opStatus":"START"}
2019-05-28 16:50:10 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-28 16:50:10 AUDIT audit:93 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756260739249883","opStatus":"SUCCESS","opTime":"186 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-28 16:50:10 AUDIT audit:72 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756260985771926","opStatus":"START"}
2019-05-28 16:50:10 AUDIT audit:93 - {"time":"May 28, 2019 9:50:10 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756260985771926","opStatus":"SUCCESS","opTime":"55 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-28 16:50:11 AUDIT audit:72 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756261119879345","opStatus":"START"}
2019-05-28 16:50:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-28 16:50:11 AUDIT audit:93 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756261119879345","opStatus":"SUCCESS","opTime":"182 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-28 16:50:11 AUDIT audit:72 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756261307215702","opStatus":"START"}
2019-05-28 16:50:11 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-28 16:50:11 AUDIT audit:93 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756261307215702","opStatus":"SUCCESS","opTime":"197 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-05-28 16:50:11 AUDIT audit:72 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18756261550768026","opStatus":"START"}
2019-05-28 16:50:11 AUDIT audit:93 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18756261550768026","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-05-28 16:50:11 AUDIT audit:72 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756261879365844","opStatus":"START"}
2019-05-28 16:50:11 AUDIT audit:93 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18756261879365844","opStatus":"SUCCESS","opTime":"72 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-28 16:50:11 AUDIT audit:72 - {"time":"May 28, 2019 9:50:11 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756261967899663","opStatus":"START"}
2019-05-28 16:50:12 AUDIT audit:93 - {"time":"May 28, 2019 9:50:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756261967899663","opStatus":"SUCCESS","opTime":"188 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-05-28 16:50:12 AUDIT audit:72 - {"time":"May 28, 2019 9:50:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756262167005211","opStatus":"START"}
2019-05-28 16:50:12 AUDIT audit:93 - {"time":"May 28, 2019 9:50:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18756262167005211","opStatus":"SUCCESS","opTime":"219 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, 17 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 #3553
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/3553/display/redirect>
------------------------------------------
[...truncated 277.41 KB...]
| 12|2012-05-22 03:00:...|
| 96|2009-11-16 07:00:...|
| 26|2013-02-14 02:00:...|
+--------+--------------------+
only showing top 20 rows
+------------------+--------------------+
| avg(age)| UDF(mytime, year)|
+------------------+--------------------+
|27.703846153846154|2019-01-01 00:00:...|
| 29.76|2006-01-01 00:00:...|
|29.634538152610443|2010-01-01 00:00:...|
| 46.0| null|
| 30.84328358208955|2018-01-01 00:00:...|
| 28.67558528428094|2017-01-01 00:00:...|
|28.565573770491802|2003-01-01 00:00:...|
|29.304761904761904|2005-01-01 00:00:...|
| 28.14644351464435|2014-01-01 00:00:...|
|28.360730593607308|2016-01-01 00:00:...|
| 29.2|2011-01-01 00:00:...|
|31.295620437956206|2015-01-01 00:00:...|
|29.571428571428573|2009-01-01 00:00:...|
| 30.48497854077253|2002-01-01 00:00:...|
|28.362204724409448|2004-01-01 00:00:...|
|28.224066390041493|2000-01-01 00:00:...|
| 30.79116465863454|2008-01-01 00:00:...|
| 30.27947598253275|2012-01-01 00:00:...|
| 28.09349593495935|2007-01-01 00:00:...|
| 27.83400809716599|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-05-29 19:40:09 AUDIT audit:72 - {"time":"May 29, 2019 12:40:09 PM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18852859099471034","opStatus":"START"}
2019-05-29 19:40:09 AUDIT audit:93 - {"time":"May 29, 2019 12:40:09 PM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18852859099471034","opStatus":"SUCCESS","opTime":"269 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-05-29 19:40:09 AUDIT audit:72 - {"time":"May 29, 2019 12:40:09 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852859420822989","opStatus":"START"}
2019-05-29 19:40:09 AUDIT audit:93 - {"time":"May 29, 2019 12:40:09 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852859420822989","opStatus":"SUCCESS","opTime":"48 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 19:40:09 AUDIT audit:72 - {"time":"May 29, 2019 12:40:09 PM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18852859470957300","opStatus":"START"}
2019-05-29 19:40:09 AUDIT audit:93 - {"time":"May 29, 2019 12:40:09 PM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18852859470957300","opStatus":"SUCCESS","opTime":"585 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.50KB","IndexSize":"720.0B"}}
2019-05-29 19:40:09 AUDIT audit:72 - {"time":"May 29, 2019 12:40:09 PM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18852860062086004","opStatus":"START"}
2019-05-29 19:40:12 AUDIT audit:93 - {"time":"May 29, 2019 12:40:12 PM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18852860062086004","opStatus":"SUCCESS","opTime":"2054 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 0|
+--------+
+--------+
|count(1)|
+--------+
| 0|
+--------+
time for query on table with lucene datamap table:0.216
time for query on table without lucene datamap table:0.146
+---+----+
| id|name|
+---+----+
+---+----+
+---+----+
| id|name|
+---+----+
+---+----+
2019-05-29 19:40:12 AUDIT audit:72 - {"time":"May 29, 2019 12:40:12 PM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18852862756177483","opStatus":"START"}
2019-05-29 19:40:12 AUDIT audit:93 - {"time":"May 29, 2019 12:40:12 PM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18852862756177483","opStatus":"SUCCESS","opTime":"102 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-05-29 19:40:12 AUDIT audit:72 - {"time":"May 29, 2019 12:40:12 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852862875879753","opStatus":"START"}
2019-05-29 19:40:12 AUDIT audit:93 - {"time":"May 29, 2019 12:40:12 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852862875879753","opStatus":"SUCCESS","opTime":"64 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 19:40:12 AUDIT audit:72 - {"time":"May 29, 2019 12:40:12 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852862946061202","opStatus":"START"}
2019-05-29 19:40:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 19:40:13 AUDIT audit:93 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852862946061202","opStatus":"SUCCESS","opTime":"178 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 19:40:13 AUDIT audit:72 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863128853970","opStatus":"START"}
2019-05-29 19:40:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 19:40:13 AUDIT audit:93 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863128853970","opStatus":"SUCCESS","opTime":"181 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 19:40:13 AUDIT audit:72 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863315828227","opStatus":"START"}
2019-05-29 19:40:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 19:40:13 AUDIT audit:93 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863315828227","opStatus":"SUCCESS","opTime":"187 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 19:40:13 AUDIT audit:72 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863508688697","opStatus":"START"}
2019-05-29 19:40:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 19:40:13 AUDIT audit:93 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863508688697","opStatus":"SUCCESS","opTime":"171 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-29 19:40:13 AUDIT audit:72 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852863734049841","opStatus":"START"}
2019-05-29 19:40:13 AUDIT audit:93 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852863734049841","opStatus":"SUCCESS","opTime":"48 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-29 19:40:13 AUDIT audit:72 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863838832891","opStatus":"START"}
2019-05-29 19:40:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 19:40:13 AUDIT audit:93 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852863838832891","opStatus":"SUCCESS","opTime":"186 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 19:40:13 AUDIT audit:72 - {"time":"May 29, 2019 12:40:13 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852864031054472","opStatus":"START"}
2019-05-29 19:40:14 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 19:40:14 AUDIT audit:93 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852864031054472","opStatus":"SUCCESS","opTime":"190 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-05-29 19:40:14 AUDIT audit:72 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18852864268730620","opStatus":"START"}
2019-05-29 19:40:14 AUDIT audit:93 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18852864268730620","opStatus":"SUCCESS","opTime":"93 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-05-29 19:40:14 AUDIT audit:72 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852864640960858","opStatus":"START"}
2019-05-29 19:40:14 AUDIT audit:93 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18852864640960858","opStatus":"SUCCESS","opTime":"50 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 19:40:14 AUDIT audit:72 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852864708670963","opStatus":"START"}
2019-05-29 19:40:14 AUDIT audit:93 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852864708670963","opStatus":"SUCCESS","opTime":"191 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-05-29 19:40:14 AUDIT audit:72 - {"time":"May 29, 2019 12:40:14 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852864910623447","opStatus":"START"}
2019-05-29 19:40:15 AUDIT audit:93 - {"time":"May 29, 2019 12:40:15 PM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18852864910623447","opStatus":"SUCCESS","opTime":"193 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 #3552
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/3552/display/redirect>
------------------------------------------
[...truncated 277.48 KB...]
| 29.6|2002-01-01 00:00:...|
|30.402542372881356|2004-01-01 00:00:...|
|30.632911392405063|2000-01-01 00:00:...|
| 30.18007662835249|2008-01-01 00:00:...|
| 27.5|2012-01-01 00:00:...|
|29.644351464435147|2007-01-01 00:00:...|
|28.857664233576642|2013-01-01 00:00:...|
|31.089494163424124|2001-01-01 00:00:...|
+------------------+--------------------+
2019-05-29 13:43:20 AUDIT audit:72 - {"time":"May 29, 2019 6:43:20 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18831450170531606","opStatus":"START"}
2019-05-29 13:43:20 AUDIT audit:93 - {"time":"May 29, 2019 6:43:20 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18831450170531606","opStatus":"SUCCESS","opTime":"287 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-05-29 13:43:20 AUDIT audit:72 - {"time":"May 29, 2019 6:43:20 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831450592525832","opStatus":"START"}
2019-05-29 13:43:20 AUDIT audit:93 - {"time":"May 29, 2019 6:43:20 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831450592525832","opStatus":"SUCCESS","opTime":"56 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 13:43:20 AUDIT audit:72 - {"time":"May 29, 2019 6:43:20 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18831450650920458","opStatus":"START"}
2019-05-29 13:43:21 AUDIT audit:93 - {"time":"May 29, 2019 6:43:21 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18831450650920458","opStatus":"SUCCESS","opTime":"706 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.38KB","IndexSize":"720.0B"}}
2019-05-29 13:43:21 AUDIT audit:72 - {"time":"May 29, 2019 6:43:21 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18831451364150283","opStatus":"START"}
2019-05-29 13:43:23 AUDIT audit:93 - {"time":"May 29, 2019 6:43:23 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18831451364150283","opStatus":"SUCCESS","opTime":"2022 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.366
time for query on table without lucene datamap table:0.236
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name1|
|which test1 good8|who and name5|
|which test1 good3|who and name7|
|which test1 good7|who and name7|
|which test1 good6|who and name2|
|which test1 good3|who and name6|
|which test1 good6|who and name1|
|which test1 good8|who and name5|
|which test1 good3|who and name7|
|which test1 good7|who and name7|
|which test1 good6|who and name2|
|which test1 good3|who and name6|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name1|
|which test1 good8|who and name5|
|which test1 good3|who and name7|
|which test1 good7|who and name7|
|which test1 good6|who and name2|
|which test1 good3|who and name6|
|which test1 good6|who and name1|
|which test1 good8|who and name5|
|which test1 good3|who and name7|
|which test1 good7|who and name7|
+-----------------+-------------+
2019-05-29 13:43:24 AUDIT audit:72 - {"time":"May 29, 2019 6:43:24 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18831454434922683","opStatus":"START"}
2019-05-29 13:43:24 AUDIT audit:93 - {"time":"May 29, 2019 6:43:24 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18831454434922683","opStatus":"SUCCESS","opTime":"124 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-05-29 13:43:24 AUDIT audit:72 - {"time":"May 29, 2019 6:43:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831454610290805","opStatus":"START"}
2019-05-29 13:43:24 AUDIT audit:93 - {"time":"May 29, 2019 6:43:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831454610290805","opStatus":"SUCCESS","opTime":"74 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 13:43:24 AUDIT audit:72 - {"time":"May 29, 2019 6:43:24 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831454691590687","opStatus":"START"}
2019-05-29 13:43:24 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 13:43:24 AUDIT audit:93 - {"time":"May 29, 2019 6:43:24 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831454691590687","opStatus":"SUCCESS","opTime":"230 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 13:43:24 AUDIT audit:72 - {"time":"May 29, 2019 6:43:24 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831454927181833","opStatus":"START"}
2019-05-29 13:43:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 13:43:25 AUDIT audit:93 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831454927181833","opStatus":"SUCCESS","opTime":"224 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 13:43:25 AUDIT audit:72 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831455157549737","opStatus":"START"}
2019-05-29 13:43:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 13:43:25 AUDIT audit:93 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831455157549737","opStatus":"SUCCESS","opTime":"238 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 13:43:25 AUDIT audit:72 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831455405221021","opStatus":"START"}
2019-05-29 13:43:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 13:43:25 AUDIT audit:93 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831455405221021","opStatus":"SUCCESS","opTime":"224 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-29 13:43:25 AUDIT audit:72 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831455723908087","opStatus":"START"}
2019-05-29 13:43:25 AUDIT audit:93 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831455723908087","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-05-29 13:43:25 AUDIT audit:72 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831455845784642","opStatus":"START"}
2019-05-29 13:43:25 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 13:43:25 AUDIT audit:93 - {"time":"May 29, 2019 6:43:25 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831455845784642","opStatus":"SUCCESS","opTime":"221 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 13:43:26 AUDIT audit:72 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831456073175750","opStatus":"START"}
2019-05-29 13:43:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 13:43:26 AUDIT audit:93 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831456073175750","opStatus":"SUCCESS","opTime":"243 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-05-29 13:43:26 AUDIT audit:72 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18831456376073411","opStatus":"START"}
2019-05-29 13:43:26 AUDIT audit:93 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18831456376073411","opStatus":"SUCCESS","opTime":"124 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-05-29 13:43:26 AUDIT audit:72 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831456741632950","opStatus":"START"}
2019-05-29 13:43:26 AUDIT audit:93 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18831456741632950","opStatus":"SUCCESS","opTime":"53 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 13:43:26 AUDIT audit:72 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831456812249759","opStatus":"START"}
2019-05-29 13:43:26 AUDIT audit:93 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831456812249759","opStatus":"SUCCESS","opTime":"186 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-05-29 13:43:26 AUDIT audit:72 - {"time":"May 29, 2019 6:43:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831457009739888","opStatus":"START"}
2019-05-29 13:43:27 AUDIT audit:93 - {"time":"May 29, 2019 6:43:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18831457009739888","opStatus":"SUCCESS","opTime":"244 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, 16 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 #3551
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/3551/display/redirect>
------------------------------------------
[...truncated 277.63 KB...]
| 8.0| null|
| 28.68487394957983|2018-01-01 00:00:...|
| 27.44214876033058|2017-01-01 00:00:...|
|28.008333333333333|2003-01-01 00:00:...|
| 28.08888888888889|2005-01-01 00:00:...|
| 27.45318352059925|2014-01-01 00:00:...|
|28.487603305785125|2016-01-01 00:00:...|
| 29.75095785440613|2011-01-01 00:00:...|
|29.816176470588236|2015-01-01 00:00:...|
|30.203187250996017|2009-01-01 00:00:...|
| 31.43027888446215|2002-01-01 00:00:...|
|28.622222222222224|2004-01-01 00:00:...|
|29.925311203319502|2000-01-01 00:00:...|
|30.021459227467812|2008-01-01 00:00:...|
|29.518382352941178|2012-01-01 00:00:...|
|27.846743295019156|2007-01-01 00:00:...|
| 28.31782945736434|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-05-29 09:52:31 AUDIT audit:72 - {"time":"May 29, 2019 2:52:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"15759786064179011","opStatus":"START"}
2019-05-29 09:52:31 AUDIT audit:93 - {"time":"May 29, 2019 2:52:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"15759786064179011","opStatus":"SUCCESS","opTime":"337 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-05-29 09:52:31 AUDIT audit:72 - {"time":"May 29, 2019 2:52:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759786454760091","opStatus":"START"}
2019-05-29 09:52:31 AUDIT audit:93 - {"time":"May 29, 2019 2:52:31 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759786454760091","opStatus":"SUCCESS","opTime":"78 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 09:52:31 AUDIT audit:72 - {"time":"May 29, 2019 2:52:31 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"15759786535687187","opStatus":"START"}
2019-05-29 09:52:32 AUDIT audit:93 - {"time":"May 29, 2019 2:52:32 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"15759786535687187","opStatus":"SUCCESS","opTime":"826 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"772.64KB","IndexSize":"720.0B"}}
2019-05-29 09:52:32 AUDIT audit:72 - {"time":"May 29, 2019 2:52:32 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"15759787371865410","opStatus":"START"}
2019-05-29 09:52:34 AUDIT audit:93 - {"time":"May 29, 2019 2:52:34 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"15759787371865410","opStatus":"SUCCESS","opTime":"2159 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 6|
+--------+
+--------+
|count(1)|
+--------+
| 6|
+--------+
time for query on table with lucene datamap table:0.293
time for query on table without lucene datamap table:0.173
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good9|who and name3|
|which test1 good0|who and name4|
|which test1 good8|who and name1|
|which test1 good9|who and name3|
|which test1 good0|who and name4|
|which test1 good8|who and name1|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good9|who and name3|
|which test1 good0|who and name4|
|which test1 good8|who and name1|
|which test1 good9|who and name3|
|which test1 good0|who and name4|
|which test1 good8|who and name1|
+-----------------+-------------+
2019-05-29 09:52:35 AUDIT audit:72 - {"time":"May 29, 2019 2:52:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"15759790398308106","opStatus":"START"}
2019-05-29 09:52:35 AUDIT audit:93 - {"time":"May 29, 2019 2:52:35 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"15759790398308106","opStatus":"SUCCESS","opTime":"129 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-05-29 09:52:35 AUDIT audit:72 - {"time":"May 29, 2019 2:52:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759790543971862","opStatus":"START"}
2019-05-29 09:52:35 AUDIT audit:93 - {"time":"May 29, 2019 2:52:35 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759790543971862","opStatus":"SUCCESS","opTime":"64 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 09:52:35 AUDIT audit:72 - {"time":"May 29, 2019 2:52:35 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759790614477796","opStatus":"START"}
2019-05-29 09:52:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 09:52:36 AUDIT audit:93 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759790614477796","opStatus":"SUCCESS","opTime":"225 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 09:52:36 AUDIT audit:72 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759790846438114","opStatus":"START"}
2019-05-29 09:52:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 09:52:36 AUDIT audit:93 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759790846438114","opStatus":"SUCCESS","opTime":"217 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 09:52:36 AUDIT audit:72 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791069408065","opStatus":"START"}
2019-05-29 09:52:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 09:52:36 AUDIT audit:93 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791069408065","opStatus":"SUCCESS","opTime":"208 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 09:52:36 AUDIT audit:72 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791283080237","opStatus":"START"}
2019-05-29 09:52:36 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 09:52:36 AUDIT audit:93 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791283080237","opStatus":"SUCCESS","opTime":"228 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-29 09:52:36 AUDIT audit:72 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759791583675517","opStatus":"START"}
2019-05-29 09:52:36 AUDIT audit:93 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759791583675517","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-05-29 09:52:36 AUDIT audit:72 - {"time":"May 29, 2019 2:52:36 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791715479080","opStatus":"START"}
2019-05-29 09:52:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 09:52:37 AUDIT audit:93 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791715479080","opStatus":"SUCCESS","opTime":"197 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 09:52:37 AUDIT audit:72 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791917711758","opStatus":"START"}
2019-05-29 09:52:37 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 09:52:37 AUDIT audit:93 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759791917711758","opStatus":"SUCCESS","opTime":"187 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-05-29 09:52:37 AUDIT audit:72 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"15759792163878980","opStatus":"START"}
2019-05-29 09:52:37 AUDIT audit:93 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"15759792163878980","opStatus":"SUCCESS","opTime":"249 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-05-29 09:52:37 AUDIT audit:72 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759792655555047","opStatus":"START"}
2019-05-29 09:52:37 AUDIT audit:93 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"15759792655555047","opStatus":"SUCCESS","opTime":"77 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 09:52:37 AUDIT audit:72 - {"time":"May 29, 2019 2:52:37 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759792754753522","opStatus":"START"}
2019-05-29 09:52:38 AUDIT audit:93 - {"time":"May 29, 2019 2:52:38 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759792754753522","opStatus":"SUCCESS","opTime":"166 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-05-29 09:52:38 AUDIT audit:72 - {"time":"May 29, 2019 2:52:38 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759792929383785","opStatus":"START"}
2019-05-29 09:52:38 AUDIT audit:93 - {"time":"May 29, 2019 2:52:38 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"15759792929383785","opStatus":"SUCCESS","opTime":"154 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 37 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3550
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/3550/display/redirect>
------------------------------------------
[...truncated 277.51 KB...]
| 19.0| null|
| 29.08076923076923|2018-01-01 00:00:...|
|28.577235772357724|2017-01-01 00:00:...|
| 28.24334600760456|2003-01-01 00:00:...|
| 28.76595744680851|2005-01-01 00:00:...|
| 29.06967213114754|2014-01-01 00:00:...|
|29.037974683544302|2016-01-01 00:00:...|
| 28.76691729323308|2011-01-01 00:00:...|
|30.815315315315317|2015-01-01 00:00:...|
|30.866666666666667|2009-01-01 00:00:...|
|31.314741035856574|2002-01-01 00:00:...|
| 29.17829457364341|2004-01-01 00:00:...|
| 29.32967032967033|2000-01-01 00:00:...|
|29.804511278195488|2008-01-01 00:00:...|
|29.444897959183674|2012-01-01 00:00:...|
| 29.625|2007-01-01 00:00:...|
|28.641221374045802|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-05-29 08:23:44 AUDIT audit:72 - {"time":"May 29, 2019 1:23:44 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18812274241566372","opStatus":"START"}
2019-05-29 08:23:44 AUDIT audit:93 - {"time":"May 29, 2019 1:23:44 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18812274241566372","opStatus":"SUCCESS","opTime":"295 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-05-29 08:23:44 AUDIT audit:72 - {"time":"May 29, 2019 1:23:44 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812274639990414","opStatus":"START"}
2019-05-29 08:23:44 AUDIT audit:93 - {"time":"May 29, 2019 1:23:44 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812274639990414","opStatus":"SUCCESS","opTime":"57 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 08:23:44 AUDIT audit:72 - {"time":"May 29, 2019 1:23:44 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18812274699970130","opStatus":"START"}
2019-05-29 08:23:45 AUDIT audit:93 - {"time":"May 29, 2019 1:23:45 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"18812274699970130","opStatus":"SUCCESS","opTime":"659 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.51KB","IndexSize":"720.0B"}}
2019-05-29 08:23:45 AUDIT audit:72 - {"time":"May 29, 2019 1:23:45 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18812275367369749","opStatus":"START"}
2019-05-29 08:23:47 AUDIT audit:93 - {"time":"May 29, 2019 1:23:47 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"18812275367369749","opStatus":"SUCCESS","opTime":"1902 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 6|
+--------+
+--------+
|count(1)|
+--------+
| 6|
+--------+
time for query on table with lucene datamap table:0.315
time for query on table without lucene datamap table:0.201
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good5|who and name4|
|which test1 good5|who and name4|
|which test1 good4|who and name2|
|which test1 good5|who and name4|
|which test1 good5|who and name4|
|which test1 good4|who and name2|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good5|who and name4|
|which test1 good5|who and name4|
|which test1 good4|who and name2|
|which test1 good5|who and name4|
|which test1 good5|who and name4|
|which test1 good4|who and name2|
+-----------------+-------------+
2019-05-29 08:23:48 AUDIT audit:72 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18812278219897391","opStatus":"START"}
2019-05-29 08:23:48 AUDIT audit:93 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18812278219897391","opStatus":"SUCCESS","opTime":"110 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-05-29 08:23:48 AUDIT audit:72 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812278350576208","opStatus":"START"}
2019-05-29 08:23:48 AUDIT audit:93 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812278350576208","opStatus":"SUCCESS","opTime":"70 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 08:23:48 AUDIT audit:72 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812278428863997","opStatus":"START"}
2019-05-29 08:23:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 08:23:48 AUDIT audit:93 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812278428863997","opStatus":"SUCCESS","opTime":"227 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 08:23:48 AUDIT audit:72 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812278662160063","opStatus":"START"}
2019-05-29 08:23:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 08:23:48 AUDIT audit:93 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812278662160063","opStatus":"SUCCESS","opTime":"203 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 08:23:48 AUDIT audit:72 - {"time":"May 29, 2019 1:23:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812278872362775","opStatus":"START"}
2019-05-29 08:23:48 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 08:23:49 AUDIT audit:93 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812278872362775","opStatus":"SUCCESS","opTime":"219 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 08:23:49 AUDIT audit:72 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812279097956332","opStatus":"START"}
2019-05-29 08:23:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 08:23:49 AUDIT audit:93 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812279097956332","opStatus":"SUCCESS","opTime":"199 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-05-29 08:23:49 AUDIT audit:72 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812279365144358","opStatus":"START"}
2019-05-29 08:23:49 AUDIT audit:93 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812279365144358","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-05-29 08:23:49 AUDIT audit:72 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812279487588523","opStatus":"START"}
2019-05-29 08:23:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 08:23:49 AUDIT audit:93 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812279487588523","opStatus":"SUCCESS","opTime":"206 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-05-29 08:23:49 AUDIT audit:72 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812279699100849","opStatus":"START"}
2019-05-29 08:23:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-05-29 08:23:49 AUDIT audit:93 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812279699100849","opStatus":"SUCCESS","opTime":"217 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-05-29 08:23:49 AUDIT audit:72 - {"time":"May 29, 2019 1:23:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18812279990617172","opStatus":"START"}
2019-05-29 08:23:50 AUDIT audit:93 - {"time":"May 29, 2019 1:23:50 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"18812279990617172","opStatus":"SUCCESS","opTime":"117 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-05-29 08:23:50 AUDIT audit:72 - {"time":"May 29, 2019 1:23:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812280402217709","opStatus":"START"}
2019-05-29 08:23:50 AUDIT audit:93 - {"time":"May 29, 2019 1:23:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"18812280402217709","opStatus":"SUCCESS","opTime":"58 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-05-29 08:23:50 AUDIT audit:72 - {"time":"May 29, 2019 1:23:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812280487049111","opStatus":"START"}
2019-05-29 08:23:50 AUDIT audit:93 - {"time":"May 29, 2019 1:23:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812280487049111","opStatus":"SUCCESS","opTime":"198 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-05-29 08:23:50 AUDIT audit:72 - {"time":"May 29, 2019 1:23:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812280695814146","opStatus":"START"}
2019-05-29 08:23:50 AUDIT audit:93 - {"time":"May 29, 2019 1:23:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"18812280695814146","opStatus":"SUCCESS","opTime":"177 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, 11 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