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/20 11:33:36 UTC
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3597
See <https://builds.apache.org/job/carbondata-master-spark-2.1/org.apache.carbondata$carbondata-examples/3597/display/redirect>
------------------------------------------
[...truncated 277.73 KB...]
|29.305555555555557|2005-01-01 00:00:...|
|29.477777777777778|2014-01-01 00:00:...|
| 30.46816479400749|2016-01-01 00:00:...|
|29.836206896551722|2011-01-01 00:00:...|
|30.593625498007967|2015-01-01 00:00:...|
|28.475609756097562|2009-01-01 00:00:...|
|30.194244604316548|2002-01-01 00:00:...|
| 29.3953488372093|2004-01-01 00:00:...|
| 29.96035242290749|2000-01-01 00:00:...|
| 30.4238683127572|2008-01-01 00:00:...|
|28.892857142857142|2012-01-01 00:00:...|
| 28.62015503875969|2007-01-01 00:00:...|
| 30.97609561752988|2013-01-01 00:00:...|
|29.551181102362204|2001-01-01 00:00:...|
+------------------+--------------------+
2019-06-20 11:31:57 AUDIT audit:72 - {"time":"June 20, 2019 4:31:57 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17666552559862335","opStatus":"START"}
2019-06-20 11:31:58 AUDIT audit:93 - {"time":"June 20, 2019 4:31:58 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17666552559862335","opStatus":"SUCCESS","opTime":"247 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-20 11:31:58 AUDIT audit:72 - {"time":"June 20, 2019 4:31:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666552921221520","opStatus":"START"}
2019-06-20 11:31:58 AUDIT audit:93 - {"time":"June 20, 2019 4:31:58 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666552921221520","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-20 11:31:58 AUDIT audit:72 - {"time":"June 20, 2019 4:31:58 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17666553017391281","opStatus":"START"}
2019-06-20 11:31:58 AUDIT audit:93 - {"time":"June 20, 2019 4:31:58 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17666553017391281","opStatus":"SUCCESS","opTime":"660 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.56KB","IndexSize":"720.0B"}}
2019-06-20 11:31:58 AUDIT audit:72 - {"time":"June 20, 2019 4:31:58 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17666553685232006","opStatus":"START"}
2019-06-20 11:32:00 AUDIT audit:93 - {"time":"June 20, 2019 4:32:00 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17666553685232006","opStatus":"SUCCESS","opTime":"1756 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.31
time for query on table without lucene datamap table:0.163
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name5|
|which test1 good2|who and name2|
|which test1 good7|who and name6|
|which test1 good7|who and name6|
|which test1 good0|who and name5|
|which test1 good2|who and name2|
|which test1 good7|who and name6|
|which test1 good7|who and name6|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name5|
|which test1 good2|who and name2|
|which test1 good7|who and name6|
|which test1 good7|who and name6|
|which test1 good0|who and name5|
|which test1 good2|who and name2|
|which test1 good7|who and name6|
|which test1 good7|who and name6|
+-----------------+-------------+
2019-06-20 11:32:01 AUDIT audit:72 - {"time":"June 20, 2019 4:32:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17666556284814770","opStatus":"START"}
2019-06-20 11:32:01 AUDIT audit:93 - {"time":"June 20, 2019 4:32:01 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17666556284814770","opStatus":"SUCCESS","opTime":"91 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-20 11:32:01 AUDIT audit:72 - {"time":"June 20, 2019 4:32:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666556388985089","opStatus":"START"}
2019-06-20 11:32:01 AUDIT audit:93 - {"time":"June 20, 2019 4:32:01 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666556388985089","opStatus":"SUCCESS","opTime":"85 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-20 11:32:01 AUDIT audit:72 - {"time":"June 20, 2019 4:32:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666556480928313","opStatus":"START"}
2019-06-20 11:32:01 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-20 11:32:01 AUDIT audit:93 - {"time":"June 20, 2019 4:32:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666556480928313","opStatus":"SUCCESS","opTime":"191 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-20 11:32:01 AUDIT audit:72 - {"time":"June 20, 2019 4:32:01 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666556676638959","opStatus":"START"}
2019-06-20 11:32:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-20 11:32:02 AUDIT audit:93 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666556676638959","opStatus":"SUCCESS","opTime":"175 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-20 11:32:02 AUDIT audit:72 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666556858915660","opStatus":"START"}
2019-06-20 11:32:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-20 11:32:02 AUDIT audit:93 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666556858915660","opStatus":"SUCCESS","opTime":"186 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-20 11:32:02 AUDIT audit:72 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666557055942826","opStatus":"START"}
2019-06-20 11:32:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-20 11:32:02 AUDIT audit:93 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666557055942826","opStatus":"SUCCESS","opTime":"196 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-20 11:32:02 AUDIT audit:72 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666557319219622","opStatus":"START"}
2019-06-20 11:32:02 AUDIT audit:93 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666557319219622","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-20 11:32:02 AUDIT audit:72 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666557450548004","opStatus":"START"}
2019-06-20 11:32:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-20 11:32:02 AUDIT audit:93 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666557450548004","opStatus":"SUCCESS","opTime":"164 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-20 11:32:02 AUDIT audit:72 - {"time":"June 20, 2019 4:32:02 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666557619337381","opStatus":"START"}
2019-06-20 11:32:02 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-20 11:32:03 AUDIT audit:93 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666557619337381","opStatus":"SUCCESS","opTime":"173 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-20 11:32:03 AUDIT audit:72 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17666557903856654","opStatus":"START"}
2019-06-20 11:32:03 AUDIT audit:93 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17666557903856654","opStatus":"SUCCESS","opTime":"87 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-20 11:32:03 AUDIT audit:72 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666558282952244","opStatus":"START"}
2019-06-20 11:32:03 AUDIT audit:93 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17666558282952244","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-20 11:32:03 AUDIT audit:72 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666558388378657","opStatus":"START"}
2019-06-20 11:32:03 AUDIT audit:93 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666558388378657","opStatus":"SUCCESS","opTime":"147 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-20 11:32:03 AUDIT audit:72 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666558544569584","opStatus":"START"}
2019-06-20 11:32:03 AUDIT audit:93 - {"time":"June 20, 2019 4:32:03 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17666558544569584","opStatus":"SUCCESS","opTime":"153 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"551.0B"}}
+---+---------+--------+
| id| name| salary|
+---+---------+--------+
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
| 1| 'liang'|200000.0|
| 2|'anubhav'| 20000.0|
+---+---------+--------+
OK
******Total Number Of Rows Fetched ****** 0
[31m- HiveExample *** FAILED ***[0m
[31m java.lang.AssertionError: assertion failed[0m
[31m at scala.Predef$.assert(Predef.scala:156)[0m
[31m at org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:153)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply$mcV$sp(RunExamples.scala:131)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.apache.carbondata.examplesCI.RunExamples$$anonfun$20.apply(RunExamples.scala:129)[0m
[31m at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)[0m
[31m at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)[0m
[31m at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:22)[0m
[31m at org.scalatest.Transformer.apply(Transformer.scala:20)[0m
[31m ...[0m
[31mException encountered when invoking run on a nested suite - Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m *** ABORTED ***[0m
[31m java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.[0m
[31mThis stopped SparkContext was created at:[0m
[31m[0m
[31morg.apache.spark.sql.test.util.QueryTest.<init>(QueryTest.scala:115)[0m
[31morg.apache.carbondata.examplesCI.RunExamples.<init>(RunExamples.scala:35)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[0m
[31msun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[0m
[31msun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[0m
[31mjava.lang.reflect.Constructor.newInstance(Constructor.java:423)[0m
[31mjava.lang.Class.newInstance(Class.java:442)[0m
[31morg.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:69)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:38)[0m
[31morg.scalatest.tools.DiscoverySuite$$anonfun$1.apply(DiscoverySuite.scala:37)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)[0m
[31mscala.collection.Iterator$class.foreach(Iterator.scala:893)[0m
[31mscala.collection.AbstractIterator.foreach(Iterator.scala:1336)[0m
[31mscala.collection.IterableLike$class.foreach(IterableLike.scala:72)[0m
[31mscala.collection.AbstractIterable.foreach(Iterable.scala:54)[0m
[31mscala.collection.TraversableLike$class.map(TraversableLike.scala:234)[0m
[31mscala.collection.AbstractTraversable.map(Traversable.scala:104)[0m
[31morg.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)[0m
[31morg.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:2390)[0m
[31m[0m
[31mThe currently active SparkContext was created at:[0m
[31m[0m
[31m(No active SparkContext.)[0m
[31m at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:716)[0m
[31m at org.apache.spark.SparkContext$$anonfun$parallelize$1.apply(SparkContext.scala:715)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)[0m
[31m at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:112)[0m
[31m at org.apache.spark.SparkContext.withScope(SparkContext.scala:701)[0m
[31m at org.apache.spark.SparkContext.parallelize(SparkContext.scala:715)[0m
[31m at org.apache.spark.sql.execution.command.ExecutedCommandExec.doExecute(commands.scala:74)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:114)[0m
[31m ...[0m
[36mRun completed in 2 minutes, 35 seconds.[0m
[36mTotal number of tests run: 20[0m
[36mSuites: completed 1, aborted 1[0m
[36mTests: succeeded 19, failed 1, canceled 0, ignored 0, pending 0[0m
[31m*** 1 SUITE ABORTED ***[0m
[31m*** 1 TEST FAILED ***[0m
[JENKINS] Recording test results
Build failed in Jenkins: carbondata-master-spark-2.1 » Apache CarbonData :: Examples #3602
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/3602/display/redirect>
------------------------------------------
[...truncated 277.68 KB...]
| 29.8515625|2015-01-01 00:00:...|
|29.053571428571427|2009-01-01 00:00:...|
|28.147321428571427|2002-01-01 00:00:...|
|28.789719626168225|2004-01-01 00:00:...|
|29.580071174377224|2000-01-01 00:00:...|
|30.018587360594797|2008-01-01 00:00:...|
| 29.18918918918919|2012-01-01 00:00:...|
|27.049429657794676|2007-01-01 00:00:...|
|29.228813559322035|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-22 09:56:23 AUDIT audit:72 - {"time":"June 22, 2019 2:56:23 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5974336889007842","opStatus":"START"}
2019-06-22 09:56:24 AUDIT audit:93 - {"time":"June 22, 2019 2:56:24 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5974336889007842","opStatus":"SUCCESS","opTime":"242 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-22 09:56:24 AUDIT audit:72 - {"time":"June 22, 2019 2:56:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974337193245696","opStatus":"START"}
2019-06-22 09:56:24 AUDIT audit:93 - {"time":"June 22, 2019 2:56:24 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974337193245696","opStatus":"SUCCESS","opTime":"97 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-22 09:56:24 AUDIT audit:72 - {"time":"June 22, 2019 2:56:24 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5974337293849568","opStatus":"START"}
2019-06-22 09:56:24 AUDIT audit:93 - {"time":"June 22, 2019 2:56:24 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5974337293849568","opStatus":"SUCCESS","opTime":"662 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.43KB","IndexSize":"720.0B"}}
2019-06-22 09:56:24 AUDIT audit:72 - {"time":"June 22, 2019 2:56:24 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5974337963102150","opStatus":"START"}
2019-06-22 09:56:27 AUDIT audit:93 - {"time":"June 22, 2019 2:56:27 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5974337963102150","opStatus":"SUCCESS","opTime":"2627 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.284
time for query on table without lucene datamap table:0.197
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name1|
|which test1 good3|who and name1|
|which test1 good0|who and name3|
|which test1 good0|who and name6|
|which test1 good2|who and name1|
|which test1 good6|who and name1|
|which test1 good3|who and name1|
|which test1 good0|who and name3|
|which test1 good0|who and name6|
|which test1 good2|who and name1|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name1|
|which test1 good3|who and name1|
|which test1 good0|who and name3|
|which test1 good0|who and name6|
|which test1 good2|who and name1|
|which test1 good6|who and name1|
|which test1 good3|who and name1|
|which test1 good0|who and name3|
|which test1 good0|who and name6|
|which test1 good2|who and name1|
+-----------------+-------------+
2019-06-22 09:56:28 AUDIT audit:72 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5974341454127503","opStatus":"START"}
2019-06-22 09:56:28 AUDIT audit:93 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5974341454127503","opStatus":"SUCCESS","opTime":"87 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-22 09:56:28 AUDIT audit:72 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974341556096261","opStatus":"START"}
2019-06-22 09:56:28 AUDIT audit:93 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974341556096261","opStatus":"SUCCESS","opTime":"69 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-22 09:56:28 AUDIT audit:72 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974341628992318","opStatus":"START"}
2019-06-22 09:56:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-22 09:56:28 AUDIT audit:93 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974341628992318","opStatus":"SUCCESS","opTime":"148 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-22 09:56:28 AUDIT audit:72 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974341780692866","opStatus":"START"}
2019-06-22 09:56:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-22 09:56:28 AUDIT audit:93 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974341780692866","opStatus":"SUCCESS","opTime":"139 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-22 09:56:28 AUDIT audit:72 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974341924450372","opStatus":"START"}
2019-06-22 09:56:28 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-22 09:56:28 AUDIT audit:93 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974341924450372","opStatus":"SUCCESS","opTime":"150 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-22 09:56:28 AUDIT audit:72 - {"time":"June 22, 2019 2:56:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974342080547516","opStatus":"START"}
2019-06-22 09:56:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-22 09:56:29 AUDIT audit:93 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974342080547516","opStatus":"SUCCESS","opTime":"150 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-22 09:56:29 AUDIT audit:72 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974342294979059","opStatus":"START"}
2019-06-22 09:56:29 AUDIT audit:93 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974342294979059","opStatus":"SUCCESS","opTime":"94 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-22 09:56:29 AUDIT audit:72 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974342452407231","opStatus":"START"}
2019-06-22 09:56:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-22 09:56:29 AUDIT audit:93 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974342452407231","opStatus":"SUCCESS","opTime":"140 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-22 09:56:29 AUDIT audit:72 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974342597744517","opStatus":"START"}
2019-06-22 09:56:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-22 09:56:29 AUDIT audit:93 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974342597744517","opStatus":"SUCCESS","opTime":"163 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-22 09:56:29 AUDIT audit:72 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5974342824691467","opStatus":"START"}
2019-06-22 09:56:29 AUDIT audit:93 - {"time":"June 22, 2019 2:56:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5974342824691467","opStatus":"SUCCESS","opTime":"100 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-22 09:56:30 AUDIT audit:72 - {"time":"June 22, 2019 2:56:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974343231045800","opStatus":"START"}
2019-06-22 09:56:30 AUDIT audit:93 - {"time":"June 22, 2019 2:56:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5974343231045800","opStatus":"SUCCESS","opTime":"101 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-22 09:56:30 AUDIT audit:72 - {"time":"June 22, 2019 2:56:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974343352480004","opStatus":"START"}
2019-06-22 09:56:30 AUDIT audit:93 - {"time":"June 22, 2019 2:56:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974343352480004","opStatus":"SUCCESS","opTime":"164 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-22 09:56:30 AUDIT audit:72 - {"time":"June 22, 2019 2:56:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974343527625966","opStatus":"START"}
2019-06-22 09:56:30 AUDIT audit:93 - {"time":"June 22, 2019 2:56:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5974343527625966","opStatus":"SUCCESS","opTime":"147 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, 52 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 #3601
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/3601/display/redirect>
------------------------------------------
[...truncated 277.61 KB...]
|28.534412955465587|2012-01-01 00:00:...|
|30.783882783882785|2007-01-01 00:00:...|
|29.195744680851064|2013-01-01 00:00:...|
|27.979757085020243|2001-01-01 00:00:...|
+------------------+--------------------+
2019-06-21 14:58:21 AUDIT audit:72 - {"time":"June 21, 2019 7:58:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5906054623549501","opStatus":"START"}
2019-06-21 14:58:21 AUDIT audit:93 - {"time":"June 21, 2019 7:58:21 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5906054623549501","opStatus":"SUCCESS","opTime":"318 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-21 14:58:22 AUDIT audit:72 - {"time":"June 21, 2019 7:58:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906055088079265","opStatus":"START"}
2019-06-21 14:58:22 AUDIT audit:93 - {"time":"June 21, 2019 7:58:22 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906055088079265","opStatus":"SUCCESS","opTime":"78 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 14:58:22 AUDIT audit:72 - {"time":"June 21, 2019 7:58:22 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5906055169393405","opStatus":"START"}
2019-06-21 14:58:22 AUDIT audit:93 - {"time":"June 21, 2019 7:58:22 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"5906055169393405","opStatus":"SUCCESS","opTime":"827 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"770.48KB","IndexSize":"720.0B"}}
2019-06-21 14:58:22 AUDIT audit:72 - {"time":"June 21, 2019 7:58:22 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5906056002562766","opStatus":"START"}
2019-06-21 14:58:25 AUDIT audit:93 - {"time":"June 21, 2019 7:58:25 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"5906056002562766","opStatus":"SUCCESS","opTime":"2661 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 16|
+--------+
+--------+
|count(1)|
+--------+
| 16|
+--------+
time for query on table with lucene datamap table:0.317
time for query on table without lucene datamap table:0.242
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name2|
|which test1 good8|who and name4|
|which test1 good7|who and name7|
|which test1 good9|who and name4|
|which test1 good9|who and name0|
|which test1 good5|who and name0|
|which test1 good4|who and name2|
|which test1 good8|who and name5|
|which test1 good0|who and name2|
|which test1 good8|who and name4|
|which test1 good7|who and name7|
|which test1 good9|who and name4|
|which test1 good9|who and name0|
|which test1 good5|who and name0|
|which test1 good4|who and name2|
|which test1 good8|who and name5|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name2|
|which test1 good8|who and name4|
|which test1 good7|who and name7|
|which test1 good9|who and name4|
|which test1 good9|who and name0|
|which test1 good5|who and name0|
|which test1 good4|who and name2|
|which test1 good8|who and name5|
|which test1 good0|who and name2|
|which test1 good8|who and name4|
+-----------------+-------------+
2019-06-21 14:58:26 AUDIT audit:72 - {"time":"June 21, 2019 7:58:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5906059591249086","opStatus":"START"}
2019-06-21 14:58:26 AUDIT audit:93 - {"time":"June 21, 2019 7:58:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5906059591249086","opStatus":"SUCCESS","opTime":"108 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-21 14:58:26 AUDIT audit:72 - {"time":"June 21, 2019 7:58:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906059721551909","opStatus":"START"}
2019-06-21 14:58:26 AUDIT audit:93 - {"time":"June 21, 2019 7:58:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906059721551909","opStatus":"SUCCESS","opTime":"70 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 14:58:26 AUDIT audit:72 - {"time":"June 21, 2019 7:58:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906059799185768","opStatus":"START"}
2019-06-21 14:58:26 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 14:58:26 AUDIT audit:93 - {"time":"June 21, 2019 7:58:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906059799185768","opStatus":"SUCCESS","opTime":"217 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 14:58:26 AUDIT audit:72 - {"time":"June 21, 2019 7:58:26 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060023986418","opStatus":"START"}
2019-06-21 14:58:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 14:58:27 AUDIT audit:93 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060023986418","opStatus":"SUCCESS","opTime":"165 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 14:58:27 AUDIT audit:72 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060195881238","opStatus":"START"}
2019-06-21 14:58:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 14:58:27 AUDIT audit:93 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060195881238","opStatus":"SUCCESS","opTime":"178 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 14:58:27 AUDIT audit:72 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060380726901","opStatus":"START"}
2019-06-21 14:58:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 14:58:27 AUDIT audit:93 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060380726901","opStatus":"SUCCESS","opTime":"167 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-21 14:58:27 AUDIT audit:72 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906060623622528","opStatus":"START"}
2019-06-21 14:58:27 AUDIT audit:93 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906060623622528","opStatus":"SUCCESS","opTime":"76 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-21 14:58:27 AUDIT audit:72 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060797011222","opStatus":"START"}
2019-06-21 14:58:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 14:58:27 AUDIT audit:93 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060797011222","opStatus":"SUCCESS","opTime":"157 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 14:58:27 AUDIT audit:72 - {"time":"June 21, 2019 7:58:27 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060960944131","opStatus":"START"}
2019-06-21 14:58:27 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 14:58:28 AUDIT audit:93 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906060960944131","opStatus":"SUCCESS","opTime":"163 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-21 14:58:28 AUDIT audit:72 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5906061197231541","opStatus":"START"}
2019-06-21 14:58:28 AUDIT audit:93 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"5906061197231541","opStatus":"SUCCESS","opTime":"113 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-21 14:58:28 AUDIT audit:72 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906061638181929","opStatus":"START"}
2019-06-21 14:58:28 AUDIT audit:93 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"5906061638181929","opStatus":"SUCCESS","opTime":"85 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 14:58:28 AUDIT audit:72 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906061742691619","opStatus":"START"}
2019-06-21 14:58:28 AUDIT audit:93 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906061742691619","opStatus":"SUCCESS","opTime":"200 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-21 14:58:28 AUDIT audit:72 - {"time":"June 21, 2019 7:58:28 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906061961002813","opStatus":"START"}
2019-06-21 14:58:29 AUDIT audit:93 - {"time":"June 21, 2019 7:58:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"5906061961002813","opStatus":"SUCCESS","opTime":"243 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 3 minutes, 1 second.[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 #3600
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/3600/display/redirect>
------------------------------------------
[...truncated 278.63 KB...]
|27.738589211618258|2000-01-01 00:00:...|
|28.734597156398106|2008-01-01 00:00:...|
|28.595238095238095|2012-01-01 00:00:...|
| 29.15625|2007-01-01 00:00:...|
| 28.69685039370079|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-21 13:18:25 AUDIT audit:72 - {"time":"June 21, 2019 6:18:25 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17759340327571082","opStatus":"START"}
2019-06-21 13:18:26 AUDIT audit:93 - {"time":"June 21, 2019 6:18:26 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17759340327571082","opStatus":"SUCCESS","opTime":"578 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-21 13:18:26 AUDIT audit:72 - {"time":"June 21, 2019 6:18:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759340988546187","opStatus":"START"}
2019-06-21 13:18:26 AUDIT audit:93 - {"time":"June 21, 2019 6:18:26 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759340988546187","opStatus":"SUCCESS","opTime":"61 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 13:18:26 AUDIT audit:72 - {"time":"June 21, 2019 6:18:26 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17759341051087484","opStatus":"START"}
2019-06-21 13:18:26 AUDIT audit:93 - {"time":"June 21, 2019 6:18:26 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17759341051087484","opStatus":"SUCCESS","opTime":"557 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.69KB","IndexSize":"720.0B"}}
2019-06-21 13:18:26 AUDIT audit:72 - {"time":"June 21, 2019 6:18:26 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17759341611730894","opStatus":"START"}
2019-06-21 13:18:28 AUDIT audit:93 - {"time":"June 21, 2019 6:18:28 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17759341611730894","opStatus":"SUCCESS","opTime":"1543 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 14|
+--------+
+--------+
|count(1)|
+--------+
| 14|
+--------+
time for query on table with lucene datamap table:0.231
time for query on table without lucene datamap table:0.15
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name0|
|which test1 good3|who and name5|
|which test1 good3|who and name1|
|which test1 good0|who and name5|
|which test1 good0|who and name3|
|which test1 good2|who and name6|
|which test1 good3|who and name4|
|which test1 good8|who and name0|
|which test1 good3|who and name5|
|which test1 good3|who and name1|
|which test1 good0|who and name5|
|which test1 good0|who and name3|
|which test1 good2|who and name6|
|which test1 good3|who and name4|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good8|who and name0|
|which test1 good3|who and name5|
|which test1 good3|who and name1|
|which test1 good0|who and name5|
|which test1 good0|who and name3|
|which test1 good2|who and name6|
|which test1 good3|who and name4|
|which test1 good8|who and name0|
|which test1 good3|who and name5|
|which test1 good3|who and name1|
+-----------------+-------------+
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17759343816284492","opStatus":"START"}
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17759343816284492","opStatus":"SUCCESS","opTime":"75 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759343902844538","opStatus":"START"}
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759343902844538","opStatus":"SUCCESS","opTime":"47 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759343952656164","opStatus":"START"}
2019-06-21 13:18:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759343952656164","opStatus":"SUCCESS","opTime":"134 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344091721382","opStatus":"START"}
2019-06-21 13:18:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344091721382","opStatus":"SUCCESS","opTime":"124 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344220457583","opStatus":"START"}
2019-06-21 13:18:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344220457583","opStatus":"SUCCESS","opTime":"127 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344351058626","opStatus":"START"}
2019-06-21 13:18:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344351058626","opStatus":"SUCCESS","opTime":"127 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759344530481072","opStatus":"START"}
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759344530481072","opStatus":"SUCCESS","opTime":"43 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344628464347","opStatus":"START"}
2019-06-21 13:18:29 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 13:18:29 AUDIT audit:93 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344628464347","opStatus":"SUCCESS","opTime":"133 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 13:18:29 AUDIT audit:72 - {"time":"June 21, 2019 6:18:29 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344767269597","opStatus":"START"}
2019-06-21 13:18:30 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 13:18:30 AUDIT audit:93 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759344767269597","opStatus":"SUCCESS","opTime":"136 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-21 13:18:30 AUDIT audit:72 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17759344956277791","opStatus":"START"}
2019-06-21 13:18:30 AUDIT audit:93 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17759344956277791","opStatus":"SUCCESS","opTime":"76 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-21 13:18:30 AUDIT audit:72 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759345262352430","opStatus":"START"}
2019-06-21 13:18:30 AUDIT audit:93 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17759345262352430","opStatus":"SUCCESS","opTime":"62 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 13:18:30 AUDIT audit:72 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759345338603273","opStatus":"START"}
2019-06-21 13:18:30 AUDIT audit:93 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759345338603273","opStatus":"SUCCESS","opTime":"120 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-21 13:18:30 AUDIT audit:72 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759345466786314","opStatus":"START"}
2019-06-21 13:18:30 AUDIT audit:93 - {"time":"June 21, 2019 6:18:30 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17759345466786314","opStatus":"SUCCESS","opTime":"120 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, 21 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 #3599
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/3599/display/redirect>
------------------------------------------
[...truncated 278.22 KB...]
|29.862595419847327|2015-01-01 00:00:...|
| 30.76953125|2009-01-01 00:00:...|
|30.739299610894943|2002-01-01 00:00:...|
|28.866412213740457|2004-01-01 00:00:...|
| 28.272|2000-01-01 00:00:...|
|29.115384615384617|2008-01-01 00:00:...|
|28.324110671936758|2012-01-01 00:00:...|
|29.289795918367346|2007-01-01 00:00:...|
| 28.57707509881423|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-21 10:16:28 AUDIT audit:72 - {"time":"June 21, 2019 3:16:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17748423303017123","opStatus":"START"}
2019-06-21 10:16:28 AUDIT audit:93 - {"time":"June 21, 2019 3:16:28 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17748423303017123","opStatus":"SUCCESS","opTime":"187 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-21 10:16:28 AUDIT audit:72 - {"time":"June 21, 2019 3:16:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748423580117386","opStatus":"START"}
2019-06-21 10:16:28 AUDIT audit:93 - {"time":"June 21, 2019 3:16:28 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748423580117386","opStatus":"SUCCESS","opTime":"59 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 10:16:28 AUDIT audit:72 - {"time":"June 21, 2019 3:16:28 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17748423640756777","opStatus":"START"}
2019-06-21 10:16:29 AUDIT audit:93 - {"time":"June 21, 2019 3:16:29 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17748423640756777","opStatus":"SUCCESS","opTime":"569 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"771.36KB","IndexSize":"720.0B"}}
2019-06-21 10:16:29 AUDIT audit:72 - {"time":"June 21, 2019 3:16:29 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17748424217333888","opStatus":"START"}
2019-06-21 10:16:31 AUDIT audit:93 - {"time":"June 21, 2019 3:16:31 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17748424217333888","opStatus":"SUCCESS","opTime":"1838 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.241
time for query on table without lucene datamap table:0.167
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name4|
|which test1 good4|who and name3|
|which test1 good9|who and name2|
|which test1 good2|who and name3|
|which test1 good2|who and name3|
|which test1 good6|who and name4|
|which test1 good4|who and name3|
|which test1 good9|who and name2|
|which test1 good2|who and name3|
|which test1 good2|who and name3|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good6|who and name4|
|which test1 good4|who and name3|
|which test1 good9|who and name2|
|which test1 good2|who and name3|
|which test1 good1|who and name7|
|which test1 good2|who and name3|
|which test1 good6|who and name4|
|which test1 good4|who and name3|
|which test1 good9|who and name2|
|which test1 good2|who and name3|
+-----------------+-------------+
2019-06-21 10:16:31 AUDIT audit:72 - {"time":"June 21, 2019 3:16:31 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17748426729586441","opStatus":"START"}
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17748426729586441","opStatus":"SUCCESS","opTime":"77 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748426818338791","opStatus":"START"}
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748426818338791","opStatus":"SUCCESS","opTime":"62 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748426884876438","opStatus":"START"}
2019-06-21 10:16:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748426884876438","opStatus":"SUCCESS","opTime":"137 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427025558158","opStatus":"START"}
2019-06-21 10:16:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427025558158","opStatus":"SUCCESS","opTime":"130 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427160325328","opStatus":"START"}
2019-06-21 10:16:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427160325328","opStatus":"SUCCESS","opTime":"124 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427287924728","opStatus":"START"}
2019-06-21 10:16:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427287924728","opStatus":"SUCCESS","opTime":"126 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748427461425784","opStatus":"START"}
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748427461425784","opStatus":"SUCCESS","opTime":"52 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-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427567745261","opStatus":"START"}
2019-06-21 10:16:32 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 10:16:32 AUDIT audit:93 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427567745261","opStatus":"SUCCESS","opTime":"126 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 10:16:32 AUDIT audit:72 - {"time":"June 21, 2019 3:16:32 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427697847151","opStatus":"START"}
2019-06-21 10:16:33 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 10:16:33 AUDIT audit:93 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748427697847151","opStatus":"SUCCESS","opTime":"124 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-21 10:16:33 AUDIT audit:72 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17748427866882830","opStatus":"START"}
2019-06-21 10:16:33 AUDIT audit:93 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17748427866882830","opStatus":"SUCCESS","opTime":"70 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-21 10:16:33 AUDIT audit:72 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748428152571196","opStatus":"START"}
2019-06-21 10:16:33 AUDIT audit:93 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17748428152571196","opStatus":"SUCCESS","opTime":"78 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 10:16:33 AUDIT audit:72 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748428247820095","opStatus":"START"}
2019-06-21 10:16:33 AUDIT audit:93 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748428247820095","opStatus":"SUCCESS","opTime":"120 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-21 10:16:33 AUDIT audit:72 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748428374954063","opStatus":"START"}
2019-06-21 10:16:33 AUDIT audit:93 - {"time":"June 21, 2019 3:16:33 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17748428374954063","opStatus":"SUCCESS","opTime":"121 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 #3598
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/3598/display/redirect>
------------------------------------------
[...truncated 278.89 KB...]
|28.276679841897234|2002-01-01 00:00:...|
| 28.33457249070632|2004-01-01 00:00:...|
| 29.95475113122172|2000-01-01 00:00:...|
|31.482625482625483|2008-01-01 00:00:...|
|28.695652173913043|2012-01-01 00:00:...|
| 30.46031746031746|2007-01-01 00:00:...|
|29.054474708171206|2013-01-01 00:00:...|
+------------------+--------------------+
only showing top 20 rows
2019-06-21 09:21:08 AUDIT audit:72 - {"time":"June 21, 2019 2:21:08 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17745103675525817","opStatus":"START"}
2019-06-21 09:21:09 AUDIT audit:93 - {"time":"June 21, 2019 2:21:09 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17745103675525817","opStatus":"SUCCESS","opTime":"219 ms","table":"default.timeseriestable","extraInfo":{}}
[32m- TimeSeriesPreAggregateTableExample[0m
2019-06-21 09:21:09 AUDIT audit:72 - {"time":"June 21, 2019 2:21:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745103981428147","opStatus":"START"}
2019-06-21 09:21:09 AUDIT audit:93 - {"time":"June 21, 2019 2:21:09 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745103981428147","opStatus":"SUCCESS","opTime":"64 ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 09:21:09 AUDIT audit:72 - {"time":"June 21, 2019 2:21:09 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17745104046741065","opStatus":"START"}
2019-06-21 09:21:09 AUDIT audit:93 - {"time":"June 21, 2019 2:21:09 AM PDT","username":"jenkins","opName":"LOAD DATA OVERWRITE","opId":"17745104046741065","opStatus":"SUCCESS","opTime":"473 ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"770.42KB","IndexSize":"720.0B"}}
2019-06-21 09:21:09 AUDIT audit:72 - {"time":"June 21, 2019 2:21:09 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17745104524195058","opStatus":"START"}
2019-06-21 09:21:11 AUDIT audit:93 - {"time":"June 21, 2019 2:21:11 AM PDT","username":"jenkins","opName":"CREATE DATAMAP","opId":"17745104524195058","opStatus":"SUCCESS","opTime":"1670 ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id , name"}}
+--------+
|count(1)|
+--------+
| 14|
+--------+
+--------+
|count(1)|
+--------+
| 14|
+--------+
time for query on table with lucene datamap table:0.178
time for query on table without lucene datamap table:0.129
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name3|
|which test1 good8|who and name0|
|which test1 good7|who and name4|
|which test1 good5|who and name7|
|which test1 good6|who and name7|
|which test1 good0|who and name1|
|which test1 good0|who and name3|
|which test1 good8|who and name0|
|which test1 good7|who and name4|
|which test1 good5|who and name7|
|which test1 good6|who and name7|
|which test1 good0|who and name1|
+-----------------+-------------+
+-----------------+-------------+
| id| name|
+-----------------+-------------+
|which test1 good0|who and name3|
|which test1 good8|who and name0|
|which test1 good7|who and name4|
|which test1 good5|who and name7|
|which test1 good6|who and name7|
|which test1 good0|who and name1|
|which test1 good1|who and name5|
|which test1 good0|who and name3|
|which test1 good8|who and name0|
|which test1 good7|who and name4|
+-----------------+-------------+
2019-06-21 09:21:11 AUDIT audit:72 - {"time":"June 21, 2019 2:21:11 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17745106734307293","opStatus":"START"}
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17745106734307293","opStatus":"SUCCESS","opTime":"181 ms","table":"default.persontable","extraInfo":{}}
[32m- LuceneDataMapExample[0m
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745106924611192","opStatus":"START"}
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745106924611192","opStatus":"SUCCESS","opTime":"45 ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745106972205999","opStatus":"START"}
2019-06-21 09:21:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745106972205999","opStatus":"SUCCESS","opTime":"127 ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107102116751","opStatus":"START"}
2019-06-21 09:21:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107102116751","opStatus":"SUCCESS","opTime":"114 ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107219894887","opStatus":"START"}
2019-06-21 09:21:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107219894887","opStatus":"SUCCESS","opTime":"113 ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107336490186","opStatus":"START"}
2019-06-21 09:21:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107336490186","opStatus":"SUCCESS","opTime":"123 ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745107501072713","opStatus":"START"}
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745107501072713","opStatus":"SUCCESS","opTime":"43 ms","table":"default.external_table","extraInfo":{"bad_record_path":"","_filelevelformat":"false","local_dictionary_enable":"true","external":"true","_external":"true","sort_columns":"","comment":""}}
+--------+
|count(1)|
+--------+
| 40|
+--------+
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107591487811","opStatus":"START"}
2019-06-21 09:21:12 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 09:21:12 AUDIT audit:93 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107591487811","opStatus":"SUCCESS","opTime":"113 ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-06-21 09:21:12 AUDIT audit:72 - {"time":"June 21, 2019 2:21:12 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107708727679","opStatus":"START"}
2019-06-21 09:21:13 ERROR DataLoadExecutor:55 - Data Load is partially success for table origin_table
2019-06-21 09:21:13 AUDIT audit:93 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745107708727679","opStatus":"SUCCESS","opTime":"127 ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
| 60|
+--------+
2019-06-21 09:21:13 AUDIT audit:72 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17745107879668325","opStatus":"START"}
2019-06-21 09:21:13 AUDIT audit:93 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"DROP TABLE","opId":"17745107879668325","opStatus":"SUCCESS","opTime":"69 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-21 09:21:13 AUDIT audit:72 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745108171426700","opStatus":"START"}
2019-06-21 09:21:13 AUDIT audit:93 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"CREATE TABLE","opId":"17745108171426700","opStatus":"SUCCESS","opTime":"65 ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-06-21 09:21:13 AUDIT audit:72 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745108250235528","opStatus":"START"}
2019-06-21 09:21:13 AUDIT audit:93 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745108250235528","opStatus":"SUCCESS","opTime":"123 ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"551.0B"}}
2019-06-21 09:21:13 AUDIT audit:72 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745108380722515","opStatus":"START"}
2019-06-21 09:21:13 AUDIT audit:93 - {"time":"June 21, 2019 2:21:13 AM PDT","username":"jenkins","opName":"LOAD DATA","opId":"17745108380722515","opStatus":"SUCCESS","opTime":"109 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, 14 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