You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by Apache Jenkins Server <je...@builds.apache.org> on 2019/06/02 08:24:15 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3565
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3565/display/redirect>
------------------------------------------
[...truncated 277.84 KB...]
|29.311203319502074|2015-01-01 00:00:...|
| 28.93625498007968|2009-01-01 00:00:...|
|29.452380952380953|2002-01-01 00:00:...|
|29.896825396825395|2004-01-01 00:00:...|
|31.188755020080322|2000-01-01 00:00:...|
|28.893004115226336|2008-01-01 00:00:...|
|30.917293233082706|2012-01-01 00:00:...|
|29.783673469387754|2007-01-01 00:00:...|
|29.236363636363638|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-02 08:22:53 AUDIT audit:72 - {"time":"June 2, 2019 1:22:53 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16100008180733535","opStatus":"START"}
2019-06-02 08:22:53 AUDIT audit:93 - {"time":"June 2, 2019 1:22:53 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16100008180733535","opStatus":"SUCCESS","opTime":"281 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-02 08:22:53 AUDIT audit:72 - {"time":"June 2, 2019 1:22:53 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100008516225483","opStatus":"START"}
2019-06-02 08:22:53 AUDIT audit:93 - {"time":"June 2, 2019 1:22:53 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100008516225483","opStatus":"SUCCESS","opTime":"74 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-02 08:22:53 AUDIT audit:72 - {"time":"June 2, 2019 1:22:53 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16100008593779904","opStatus":"START"}
2019-06-02 08:22:54 AUDIT audit:93 - {"time":"June 2, 2019 1:22:54 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16100008593779904","opStatus":"SUCCESS","opTime":"727 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.50KB","IndexSize":"720.0B"}}
2019-06-02 08:22:54 AUDIT audit:72 - {"time":"June 2, 2019 1:22:54 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16100009327603835","opStatus":"START"}
2019-06-02 08:22:56 AUDIT audit:93 - {"time":"June 2, 2019 1:22:56 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16100009327603835","opStatus":"SUCCESS","opTime":"2221 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.235
time for query on table without lucene datamap table:0.189
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good5|who and name6|
|which test1 good4|who and name2|
|which test1 good6|who and name4|
|which test1 good8|who and name4|
|which test1 good6|who and name1|
|which test1 good5|who and name6|
|which test1 good4|who and name2|
|which test1 good6|who and name4|
|which test1 good8|who and name4|
|which test1 good6|who and name1|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good5|who and name6|
|which test1 good4|who and name2|
|which test1 good6|who and name4|
|which test1 good8|who and name4|
|which test1 good1|who and name2|
|which test1 good6|who and name1|
|which test1 good5|who and name6|
|which test1 good4|who and name2|
|which test1 good6|who and name4|
|which test1 good8|who and name4|
+-----------------+-------------+
2019-06-02 08:22:57 AUDIT audit:72 - {"time":"June 2, 2019 1:22:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16100012311631554","opStatus":"START"}
2019-06-02 08:22:57 AUDIT audit:93 - {"time":"June 2, 2019 1:22:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16100012311631554","opStatus":"SUCCESS","opTime":"101 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-02 08:22:57 AUDIT audit:72 - {"time":"June 2, 2019 1:22:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100012427302367","opStatus":"START"}
2019-06-02 08:22:57 AUDIT audit:93 - {"time":"June 2, 2019 1:22:57 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100012427302367","opStatus":"SUCCESS","opTime":"81 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-02 08:22:57 AUDIT audit:72 - {"time":"June 2, 2019 1:22:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100012515987036","opStatus":"START"}
2019-06-02 08:22:57 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-02 08:22:57 AUDIT audit:93 - {"time":"June 2, 2019 1:22:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100012515987036","opStatus":"SUCCESS","opTime":"221 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-02 08:22:57 AUDIT audit:72 - {"time":"June 2, 2019 1:22:57 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100012744322831","opStatus":"START"}
2019-06-02 08:22:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-02 08:22:58 AUDIT audit:93 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100012744322831","opStatus":"SUCCESS","opTime":"198 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-02 08:22:58 AUDIT audit:72 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100012949721148","opStatus":"START"}
2019-06-02 08:22:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-02 08:22:58 AUDIT audit:93 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100012949721148","opStatus":"SUCCESS","opTime":"205 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-02 08:22:58 AUDIT audit:72 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100013160157535","opStatus":"START"}
2019-06-02 08:22:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-02 08:22:58 AUDIT audit:93 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100013160157535","opStatus":"SUCCESS","opTime":"196 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-02 08:22:58 AUDIT audit:72 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100013419173396","opStatus":"START"}
2019-06-02 08:22:58 AUDIT audit:93 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100013419173396","opStatus":"SUCCESS","opTime":"61 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-02 08:22:58 AUDIT audit:72 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100013547007268","opStatus":"START"}
2019-06-02 08:22:58 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-02 08:22:58 AUDIT audit:93 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100013547007268","opStatus":"SUCCESS","opTime":"189 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-02 08:22:58 AUDIT audit:72 - {"time":"June 2, 2019 1:22:58 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100013741096847","opStatus":"START"}
2019-06-02 08:22:59 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-02 08:22:59 AUDIT audit:93 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100013741096847","opStatus":"SUCCESS","opTime":"206 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-02 08:22:59 AUDIT audit:72 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16100014028369568","opStatus":"START"}
2019-06-02 08:22:59 AUDIT audit:93 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16100014028369568","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-06-02 08:22:59 AUDIT audit:72 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100014442674304","opStatus":"START"}
2019-06-02 08:22:59 AUDIT audit:93 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16100014442674304","opStatus":"SUCCESS","opTime":"79 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-02 08:22:59 AUDIT audit:72 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100014542428058","opStatus":"START"}
2019-06-02 08:22:59 AUDIT audit:93 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100014542428058","opStatus":"SUCCESS","opTime":"167 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-02 08:22:59 AUDIT audit:72 - {"time":"June 2, 2019 1:22:59 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100014719235043","opStatus":"START"}
2019-06-02 08:23:00 AUDIT audit:93 - {"time":"June 2, 2019 1:23:00 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16100014719235043","opStatus":"SUCCESS","opTime":"182 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 36 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 #3568
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/3568/display/redirect>
------------------------------------------
[...truncated 278.13 KB...]
| 29.296875|2015-01-01 00:00:...|
|30.104347826086958|2009-01-01 00:00:...|
| 28.232|2002-01-01 00:00:...|
|29.206611570247933|2004-01-01 00:00:...|
| 29.54251012145749|2000-01-01 00:00:...|
| 31.08730158730159|2008-01-01 00:00:...|
|30.012448132780083|2012-01-01 00:00:...|
|27.743682310469314|2007-01-01 00:00:...|
| 29.42910447761194|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-05 09:34:44 AUDIT audit:72 - {"time":"June 5, 2019 2:34:44 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19421335060063404","opStatus":"START"}
2019-06-05 09:34:45 AUDIT audit:93 - {"time":"June 5, 2019 2:34:45 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19421335060063404","opStatus":"SUCCESS","opTime":"180 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-05 09:34:45 AUDIT audit:72 - {"time":"June 5, 2019 2:34:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421335351409162","opStatus":"START"}
2019-06-05 09:34:45 AUDIT audit:93 - {"time":"June 5, 2019 2:34:45 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421335351409162","opStatus":"SUCCESS","opTime":"57 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-05 09:34:45 AUDIT audit:72 - {"time":"June 5, 2019 2:34:45 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"19421335411391631","opStatus":"START"}
2019-06-05 09:34:46 AUDIT audit:93 - {"time":"June 5, 2019 2:34:46 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"19421335411391631","opStatus":"SUCCESS","opTime":"783 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.83KB","IndexSize":"720.0B"}}
2019-06-05 09:34:46 AUDIT audit:72 - {"time":"June 5, 2019 2:34:46 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"19421336208469497","opStatus":"START"}
2019-06-05 09:34:48 AUDIT audit:93 - {"time":"June 5, 2019 2:34:48 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"19421336208469497","opStatus":"SUCCESS","opTime":"2340 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.393
time for query on table without lucene datamap table:0.218
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name3|
|which test1 good4|who and name6|
|which test1 good7|who and name5|
|which test1 good9|who and name5|
|which test1 good8|who and name4|
|which test1 good2|who and name3|
|which test1 good4|who and name6|
|which test1 good7|who and name5|
|which test1 good9|who and name5|
|which test1 good8|who and name4|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name3|
|which test1 good4|who and name6|
|which test1 good7|who and name5|
|which test1 good9|who and name5|
|which test1 good8|who and name4|
|which test1 good2|who and name3|
|which test1 good4|who and name6|
|which test1 good7|who and name5|
|which test1 good9|who and name5|
|which test1 good8|who and name4|
+-----------------+-------------+
2019-06-05 09:34:49 AUDIT audit:72 - {"time":"June 5, 2019 2:34:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19421339507061350","opStatus":"START"}
2019-06-05 09:34:49 AUDIT audit:93 - {"time":"June 5, 2019 2:34:49 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19421339507061350","opStatus":"SUCCESS","opTime":"88 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-05 09:34:49 AUDIT audit:72 - {"time":"June 5, 2019 2:34:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421339615137185","opStatus":"START"}
2019-06-05 09:34:49 AUDIT audit:93 - {"time":"June 5, 2019 2:34:49 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421339615137185","opStatus":"SUCCESS","opTime":"69 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-05 09:34:49 AUDIT audit:72 - {"time":"June 5, 2019 2:34:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421339691728524","opStatus":"START"}
2019-06-05 09:34:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-05 09:34:49 AUDIT audit:93 - {"time":"June 5, 2019 2:34:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421339691728524","opStatus":"SUCCESS","opTime":"214 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-05 09:34:49 AUDIT audit:72 - {"time":"June 5, 2019 2:34:49 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421339911939536","opStatus":"START"}
2019-06-05 09:34:49 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-05 09:34:50 AUDIT audit:93 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421339911939536","opStatus":"SUCCESS","opTime":"196 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-05 09:34:50 AUDIT audit:72 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421340115595808","opStatus":"START"}
2019-06-05 09:34:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-05 09:34:50 AUDIT audit:93 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421340115595808","opStatus":"SUCCESS","opTime":"232 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-05 09:34:50 AUDIT audit:72 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421340355852596","opStatus":"START"}
2019-06-05 09:34:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-05 09:34:50 AUDIT audit:93 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421340355852596","opStatus":"SUCCESS","opTime":"240 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-05 09:34:50 AUDIT audit:72 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421340674832417","opStatus":"START"}
2019-06-05 09:34:50 AUDIT audit:93 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421340674832417","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-06-05 09:34:50 AUDIT audit:72 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421340801823240","opStatus":"START"}
2019-06-05 09:34:50 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-05 09:34:50 AUDIT audit:93 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421340801823240","opStatus":"SUCCESS","opTime":"209 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-05 09:34:50 AUDIT audit:72 - {"time":"June 5, 2019 2:34:50 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421341019761248","opStatus":"START"}
2019-06-05 09:34:51 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-05 09:34:51 AUDIT audit:93 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421341019761248","opStatus":"SUCCESS","opTime":"228 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-05 09:34:51 AUDIT audit:72 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19421341354854173","opStatus":"START"}
2019-06-05 09:34:51 AUDIT audit:93 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"19421341354854173","opStatus":"SUCCESS","opTime":"72 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-05 09:34:51 AUDIT audit:72 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421341727473573","opStatus":"START"}
2019-06-05 09:34:51 AUDIT audit:93 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"19421341727473573","opStatus":"SUCCESS","opTime":"83 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-05 09:34:51 AUDIT audit:72 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421341829349322","opStatus":"START"}
2019-06-05 09:34:51 AUDIT audit:93 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421341829349322","opStatus":"SUCCESS","opTime":"210 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-05 09:34:51 AUDIT audit:72 - {"time":"June 5, 2019 2:34:51 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421342051006082","opStatus":"START"}
2019-06-05 09:34:52 AUDIT audit:93 - {"time":"June 5, 2019 2:34:52 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"19421342051006082","opStatus":"SUCCESS","opTime":"201 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, 10 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 #3567
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/3567/display/redirect>
------------------------------------------
[...truncated 282.93 KB...]
|29.054945054945055|2005-01-01 00:00:...|
| 29.08502024291498|2014-01-01 00:00:...|
|31.819277108433734|2016-01-01 00:00:...|
|28.717842323651453|2015-01-01 00:00:...|
| 28.888|2011-01-01 00:00:...|
|28.711111111111112|2009-01-01 00:00:...|
|29.103448275862068|2002-01-01 00:00:...|
|29.130252100840337|2004-01-01 00:00:...|
| 29.96825396825397|2000-01-01 00:00:...|
| 29.67680608365019|2008-01-01 00:00:...|
| 31.52742616033755|2012-01-01 00:00:...|
|27.873015873015873|2007-01-01 00:00:...|
| 30.46153846153846|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-04 10:04:41 AUDIT audit:72 - {"time":"June 4, 2019 3:04:41 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16390392978818226","opStatus":"START"}
2019-06-04 10:04:41 AUDIT audit:93 - {"time":"June 4, 2019 3:04:41 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16390392978818226","opStatus":"SUCCESS","opTime":"260 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-04 10:04:41 AUDIT audit:72 - {"time":"June 4, 2019 3:04:41 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390393290214353","opStatus":"START"}
2019-06-04 10:04:41 AUDIT audit:93 - {"time":"June 4, 2019 3:04:41 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390393290214353","opStatus":"SUCCESS","opTime":"81 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-04 10:04:41 AUDIT audit:72 - {"time":"June 4, 2019 3:04:41 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16390393374425774","opStatus":"START"}
2019-06-04 10:04:42 AUDIT audit:93 - {"time":"June 4, 2019 3:04:42 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16390393374425774","opStatus":"SUCCESS","opTime":"671 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.43KB","IndexSize":"720.0B"}}
2019-06-04 10:04:42 AUDIT audit:72 - {"time":"June 4, 2019 3:04:42 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16390394050963025","opStatus":"START"}
2019-06-04 10:04:45 AUDIT audit:93 - {"time":"June 4, 2019 3:04:45 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16390394050963025","opStatus":"SUCCESS","opTime":"2700 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 8|
+--------+
+--------+
|count(1)|
+--------+
| 8|
+--------+
time for query on table with lucene datamap table:0.306
time for query on table without lucene datamap table:0.272
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name6|
|which test1 good5|who and name7|
|which test1 good8|who and name3|
|which test1 good0|who and name0|
|which test1 good4|who and name6|
|which test1 good5|who and name7|
|which test1 good8|who and name3|
|which test1 good0|who and name0|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good4|who and name6|
|which test1 good5|who and name7|
|which test1 good8|who and name3|
|which test1 good0|who and name0|
|which test1 good4|who and name6|
|which test1 good5|who and name7|
|which test1 good8|who and name3|
|which test1 good0|who and name0|
+-----------------+-------------+
2019-06-04 10:04:46 AUDIT audit:72 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16390397698350223","opStatus":"START"}
2019-06-04 10:04:46 AUDIT audit:93 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16390397698350223","opStatus":"SUCCESS","opTime":"123 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-04 10:04:46 AUDIT audit:72 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390397842791261","opStatus":"START"}
2019-06-04 10:04:46 AUDIT audit:93 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390397842791261","opStatus":"SUCCESS","opTime":"78 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-04 10:04:46 AUDIT audit:72 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390397927951389","opStatus":"START"}
2019-06-04 10:04:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-04 10:04:46 AUDIT audit:93 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390397927951389","opStatus":"SUCCESS","opTime":"234 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-04 10:04:46 AUDIT audit:72 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390398168281825","opStatus":"START"}
2019-06-04 10:04:46 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-04 10:04:46 AUDIT audit:93 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390398168281825","opStatus":"SUCCESS","opTime":"201 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-04 10:04:46 AUDIT audit:72 - {"time":"June 4, 2019 3:04:46 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390398375870313","opStatus":"START"}
2019-06-04 10:04:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-04 10:04:47 AUDIT audit:93 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390398375870313","opStatus":"SUCCESS","opTime":"204 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-04 10:04:47 AUDIT audit:72 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390398585747451","opStatus":"START"}
2019-06-04 10:04:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-04 10:04:47 AUDIT audit:93 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390398585747451","opStatus":"SUCCESS","opTime":"205 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-04 10:04:47 AUDIT audit:72 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390398866207921","opStatus":"START"}
2019-06-04 10:04:47 AUDIT audit:93 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390398866207921","opStatus":"SUCCESS","opTime":"63 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-04 10:04:47 AUDIT audit:72 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390399027677188","opStatus":"START"}
2019-06-04 10:04:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-04 10:04:47 AUDIT audit:93 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390399027677188","opStatus":"SUCCESS","opTime":"222 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-04 10:04:47 AUDIT audit:72 - {"time":"June 4, 2019 3:04:47 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390399255102590","opStatus":"START"}
2019-06-04 10:04:47 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-04 10:04:48 AUDIT audit:93 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390399255102590","opStatus":"SUCCESS","opTime":"202 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-04 10:04:48 AUDIT audit:72 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16390399525008820","opStatus":"START"}
2019-06-04 10:04:48 AUDIT audit:93 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16390399525008820","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-06-04 10:04:48 AUDIT audit:72 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390399927169105","opStatus":"START"}
2019-06-04 10:04:48 AUDIT audit:93 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16390399927169105","opStatus":"SUCCESS","opTime":"77 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-04 10:04:48 AUDIT audit:72 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390400021362062","opStatus":"START"}
2019-06-04 10:04:48 AUDIT audit:93 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390400021362062","opStatus":"SUCCESS","opTime":"198 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-04 10:04:48 AUDIT audit:72 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390400229870094","opStatus":"START"}
2019-06-04 10:04:48 AUDIT audit:93 - {"time":"June 4, 2019 3:04:48 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16390400229870094","opStatus":"SUCCESS","opTime":"209 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, 50 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 #3566
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/3566/display/redirect>
------------------------------------------
[...truncated 277.67 KB...]
|31.127208480565372|2017-01-01 00:00:...|
|31.035714285714285|2003-01-01 00:00:...|
|29.097014925373134|2005-01-01 00:00:...|
|29.647727272727273|2014-01-01 00:00:...|
|30.673003802281368|2016-01-01 00:00:...|
|30.076045627376427|2011-01-01 00:00:...|
| 28.46887966804979|2015-01-01 00:00:...|
| 30.94980694980695|2009-01-01 00:00:...|
|29.014545454545456|2002-01-01 00:00:...|
| 30.17479674796748|2004-01-01 00:00:...|
|28.540425531914895|2000-01-01 00:00:...|
| 30.31923076923077|2008-01-01 00:00:...|
|28.004273504273506|2012-01-01 00:00:...|
| 27.78688524590164|2007-01-01 00:00:...|
|29.780269058295964|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-03 09:39:59 AUDIT audit:72 - {"time":"June 3, 2019 2:39:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16190826926914202","opStatus":"START"}
2019-06-03 09:39:59 AUDIT audit:93 - {"time":"June 3, 2019 2:39:59 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16190826926914202","opStatus":"SUCCESS","opTime":"222 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-03 09:39:59 AUDIT audit:72 - {"time":"June 3, 2019 2:39:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190827241024870","opStatus":"START"}
2019-06-03 09:39:59 AUDIT audit:93 - {"time":"June 3, 2019 2:39:59 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190827241024870","opStatus":"SUCCESS","opTime":"88 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-03 09:39:59 AUDIT audit:72 - {"time":"June 3, 2019 2:39:59 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16190827331654574","opStatus":"START"}
2019-06-03 09:40:00 AUDIT audit:93 - {"time":"June 3, 2019 2:40:00 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"16190827331654574","opStatus":"SUCCESS","opTime":"681 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.50KB","IndexSize":"720.0B"}}
2019-06-03 09:40:00 AUDIT audit:72 - {"time":"June 3, 2019 2:40:00 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16190828017879509","opStatus":"START"}
2019-06-03 09:40:02 AUDIT audit:93 - {"time":"June 3, 2019 2:40:02 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"16190828017879509","opStatus":"SUCCESS","opTime":"2160 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 8|
+--------+
+--------+
|count(1)|
+--------+
| 8|
+--------+
time for query on table with lucene datamap table:0.271
time for query on table without lucene datamap table:0.218
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good2|who and name2|
|which test1 good9|who and name4|
|which test1 good6|who and name5|
|which test1 good2|who and name2|
|which test1 good9|who and name4|
|which test1 good6|who and name5|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good1|who and name2|
|which test1 good2|who and name2|
|which test1 good9|who and name4|
|which test1 good6|who and name5|
|which test1 good1|who and name2|
|which test1 good2|who and name2|
|which test1 good9|who and name4|
|which test1 good6|who and name5|
+-----------------+-------------+
2019-06-03 09:40:03 AUDIT audit:72 - {"time":"June 3, 2019 2:40:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16190830993253919","opStatus":"START"}
2019-06-03 09:40:03 AUDIT audit:93 - {"time":"June 3, 2019 2:40:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16190830993253919","opStatus":"SUCCESS","opTime":"107 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-03 09:40:03 AUDIT audit:72 - {"time":"June 3, 2019 2:40:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190831115332402","opStatus":"START"}
2019-06-03 09:40:03 AUDIT audit:93 - {"time":"June 3, 2019 2:40:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190831115332402","opStatus":"SUCCESS","opTime":"71 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-03 09:40:03 AUDIT audit:72 - {"time":"June 3, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831192345008","opStatus":"START"}
2019-06-03 09:40:03 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-03 09:40:03 AUDIT audit:93 - {"time":"June 3, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831192345008","opStatus":"SUCCESS","opTime":"200 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-03 09:40:03 AUDIT audit:72 - {"time":"June 3, 2019 2:40:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831397993052","opStatus":"START"}
2019-06-03 09:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-03 09:40:04 AUDIT audit:93 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831397993052","opStatus":"SUCCESS","opTime":"197 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-03 09:40:04 AUDIT audit:72 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831600609075","opStatus":"START"}
2019-06-03 09:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-03 09:40:04 AUDIT audit:93 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831600609075","opStatus":"SUCCESS","opTime":"191 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-03 09:40:04 AUDIT audit:72 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831798289192","opStatus":"START"}
2019-06-03 09:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-03 09:40:04 AUDIT audit:93 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190831798289192","opStatus":"SUCCESS","opTime":"206 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-03 09:40:04 AUDIT audit:72 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190832075195054","opStatus":"START"}
2019-06-03 09:40:04 AUDIT audit:93 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190832075195054","opStatus":"SUCCESS","opTime":"59 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-03 09:40:04 AUDIT audit:72 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190832194770498","opStatus":"START"}
2019-06-03 09:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-03 09:40:04 AUDIT audit:93 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190832194770498","opStatus":"SUCCESS","opTime":"163 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-03 09:40:04 AUDIT audit:72 - {"time":"June 3, 2019 2:40:04 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190832363260895","opStatus":"START"}
2019-06-03 09:40:04 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-03 09:40:05 AUDIT audit:93 - {"time":"June 3, 2019 2:40:05 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190832363260895","opStatus":"SUCCESS","opTime":"172 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-03 09:40:05 AUDIT audit:72 - {"time":"June 3, 2019 2:40:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16190832588433431","opStatus":"START"}
2019-06-03 09:40:05 AUDIT audit:93 - {"time":"June 3, 2019 2:40:05 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"16190832588433431","opStatus":"SUCCESS","opTime":"92 ms","table":"default.origin_table","extraInfo":{}}
[32m- ExternalTableExample[0m
Data:
0 robot0 0 0 9223372036854775807 0.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
1 robot1 1 1 9223372036854775806 0.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
2 robot2 2 2 9223372036854775805 1.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
3 robot3 3 3 9223372036854775804 1.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
4 robot4 4 4 9223372036854775803 2.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
5 robot5 5 5 9223372036854775802 2.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
6 robot6 6 6 9223372036854775801 3.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
7 robot7 7 7 9223372036854775800 3.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
8 robot8 8 8 9223372036854775799 4.0 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
9 robot9 9 9 9223372036854775798 4.5 true 2019-03-01 2019-02-12 03:03:34.0 12.35 varchar
Hello World From Carbon
Data:
0 robot0 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 0 0 9223372036854775807 0.0 true 12.35
1 robot1 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 1 1 9223372036854775806 0.5 true 12.35
2 robot2 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 2 2 9223372036854775805 1.0 true 12.35
3 robot3 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 3 3 9223372036854775804 1.5 true 12.35
4 robot4 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 4 4 9223372036854775803 2.0 true 12.35
5 robot5 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 5 5 9223372036854775802 2.5 true 12.35
6 robot6 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 6 6 9223372036854775801 3.0 true 12.35
7 robot7 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 7 7 9223372036854775800 3.5 true 12.35
8 robot8 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 8 8 9223372036854775799 4.0 true 12.35
9 robot9 2019-03-01 2019-02-12 03:03:34.0 varchar Hello World From Carbon 9 9 9223372036854775798 4.5 true 12.35
[32m- CarbonReaderExample[0m
2019-06-03 09:40:05 AUDIT audit:72 - {"time":"June 3, 2019 2:40:05 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190832929245708","opStatus":"START"}
2019-06-03 09:40:06 AUDIT audit:93 - {"time":"June 3, 2019 2:40:06 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"16190832929245708","opStatus":"SUCCESS","opTime":"1366 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-03 09:40:06 AUDIT audit:72 - {"time":"June 3, 2019 2:40:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190834321301827","opStatus":"START"}
2019-06-03 09:40:06 AUDIT audit:93 - {"time":"June 3, 2019 2:40:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190834321301827","opStatus":"SUCCESS","opTime":"183 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-03 09:40:06 AUDIT audit:72 - {"time":"June 3, 2019 2:40:06 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190834513404623","opStatus":"START"}
2019-06-03 09:40:07 AUDIT audit:93 - {"time":"June 3, 2019 2:40:07 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"16190834513404623","opStatus":"SUCCESS","opTime":"181 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, 40 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