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

Changes:


------------------------------------------
[...truncated 263.01 KB...]
|28.200836820083683|2002-01-01 00:00:...|
|29.535055350553506|2004-01-01 00:00:...|
|27.666666666666668|2000-01-01 00:00:...|
|28.622317596566525|2008-01-01 00:00:...|
|        30.0234375|2012-01-01 00:00:...|
| 30.50210970464135|2007-01-01 00:00:...|
|29.568464730290458|2013-01-01 00:00:...|
| 31.46058091286307|2001-01-01 00:00:...|
+------------------+--------------------+

2019-11-01 03:46:34 AUDIT audit:72 - {"time":"October 31, 2019 8:46:34 PM 
PDT","username":"jenkins","opName":"DROP 
TABLE","opId":"5767108256203272","opStatus":"START"}
2019-11-01 03:46:35 AUDIT audit:93 - {"time":"October 31, 2019 8:46:35 PM 
PDT","username":"jenkins","opName":"DROP 
TABLE","opId":"5767108256203272","opStatus":"SUCCESS","opTime":"214 
ms","table":"default.timeseriestable","extraInfo":{}}
- TimeSeriesPreAggregateTableExample
2019-11-01 03:46:35 AUDIT audit:72 - {"time":"October 31, 2019 8:46:35 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767108513055961","opStatus":"START"}
2019-11-01 03:46:35 AUDIT audit:93 - {"time":"October 31, 2019 8:46:35 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767108513055961","opStatus":"SUCCESS","opTime":"46 
ms","table":"default.persontable","extraInfo":{"bad_record_path":"","streaming":"false","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-11-01 03:46:35 AUDIT audit:72 - {"time":"October 31, 2019 8:46:35 PM 
PDT","username":"jenkins","opName":"LOAD DATA 
OVERWRITE","opId":"5767108561369827","opStatus":"START"}
2019-11-01 03:46:35 AUDIT audit:93 - {"time":"October 31, 2019 8:46:35 PM 
PDT","username":"jenkins","opName":"LOAD DATA 
OVERWRITE","opId":"5767108561369827","opStatus":"SUCCESS","opTime":"564 
ms","table":"default.personTable","extraInfo":{"SegmentId":"0","DataSize":"770.62KB","IndexSize":"724.0B"}}
2019-11-01 03:46:35 AUDIT audit:72 - {"time":"October 31, 2019 8:46:35 PM 
PDT","username":"jenkins","opName":"CREATE 
DATAMAP","opId":"5767109132436843","opStatus":"START"}
2019-11-01 03:46:37 AUDIT audit:93 - {"time":"October 31, 2019 8:46:37 PM 
PDT","username":"jenkins","opName":"CREATE 
DATAMAP","opId":"5767109132436843","opStatus":"SUCCESS","opTime":"1600 
ms","table":"default.persontable","extraInfo":{"provider":"lucene","dmName":"dm","index_columns":"id
 , name"}}
+--------+
|count(1)|
+--------+
|       0|
+--------+

+--------+
|count(1)|
+--------+
|       0|
+--------+

time for query on table with lucene datamap table:0.224
time for query on table without lucene datamap table:0.152
+---+----+
| id|name|
+---+----+
+---+----+

+---+----+
| id|name|
+---+----+
+---+----+

2019-11-01 03:46:37 AUDIT audit:72 - {"time":"October 31, 2019 8:46:37 PM 
PDT","username":"jenkins","opName":"DROP 
TABLE","opId":"5767111394540430","opStatus":"START"}
2019-11-01 03:46:38 AUDIT audit:93 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"DROP 
TABLE","opId":"5767111394540430","opStatus":"SUCCESS","opTime":"80 
ms","table":"default.persontable","extraInfo":{}}
- LuceneDataMapExample
2019-11-01 03:46:38 AUDIT audit:72 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767111485038282","opStatus":"START"}
2019-11-01 03:46:38 AUDIT audit:93 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767111485038282","opStatus":"SUCCESS","opTime":"54 
ms","table":"default.origin_table","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-11-01 03:46:38 AUDIT audit:72 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767111542680244","opStatus":"START"}
2019-11-01 03:46:38 ERROR DataLoadExecutor:55 - Data Load is partially success 
for table origin_table
2019-11-01 03:46:38 AUDIT audit:93 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767111542680244","opStatus":"SUCCESS","opTime":"219 
ms","table":"default.origin_table","extraInfo":{"SegmentId":"0","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-11-01 03:46:38 AUDIT audit:72 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767111766769237","opStatus":"START"}
2019-11-01 03:46:38 ERROR DataLoadExecutor:55 - Data Load is partially success 
for table origin_table
2019-11-01 03:46:38 AUDIT audit:93 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767111766769237","opStatus":"SUCCESS","opTime":"140 
ms","table":"default.origin_table","extraInfo":{"SegmentId":"1","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-11-01 03:46:38 AUDIT audit:72 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767111910977974","opStatus":"START"}
2019-11-01 03:46:38 ERROR DataLoadExecutor:55 - Data Load is partially success 
for table origin_table
2019-11-01 03:46:38 AUDIT audit:93 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767111910977974","opStatus":"SUCCESS","opTime":"141 
ms","table":"default.origin_table","extraInfo":{"SegmentId":"2","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-11-01 03:46:38 AUDIT audit:72 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767112057832132","opStatus":"START"}
2019-11-01 03:46:38 ERROR DataLoadExecutor:55 - Data Load is partially success 
for table origin_table
2019-11-01 03:46:38 AUDIT audit:93 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767112057832132","opStatus":"SUCCESS","opTime":"149 
ms","table":"default.origin_table","extraInfo":{"SegmentId":"3","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      40|
+--------+

2019-11-01 03:46:38 AUDIT audit:72 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767112257844483","opStatus":"START"}
2019-11-01 03:46:38 AUDIT audit:93 - {"time":"October 31, 2019 8:46:38 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767112257844483","opStatus":"SUCCESS","opTime":"50 
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-11-01 03:46:39 AUDIT audit:72 - {"time":"October 31, 2019 8:46:39 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767112482942097","opStatus":"START"}
2019-11-01 03:46:39 ERROR DataLoadExecutor:55 - Data Load is partially success 
for table origin_table
2019-11-01 03:46:39 AUDIT audit:93 - {"time":"October 31, 2019 8:46:39 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767112482942097","opStatus":"SUCCESS","opTime":"138 
ms","table":"default.origin_table","extraInfo":{"SegmentId":"4","DataSize":"2.85KB","IndexSize":"1.43KB"}}
2019-11-01 03:46:39 AUDIT audit:72 - {"time":"October 31, 2019 8:46:39 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767112627529923","opStatus":"START"}
2019-11-01 03:46:39 ERROR DataLoadExecutor:55 - Data Load is partially success 
for table origin_table
2019-11-01 03:46:39 AUDIT audit:93 - {"time":"October 31, 2019 8:46:39 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767112627529923","opStatus":"SUCCESS","opTime":"172 
ms","table":"default.origin_table","extraInfo":{"SegmentId":"5","DataSize":"2.85KB","IndexSize":"1.43KB"}}
+--------+
|count(1)|
+--------+
|      60|
+--------+

2019-11-01 03:46:39 AUDIT audit:72 - {"time":"October 31, 2019 8:46:39 PM 
PDT","username":"jenkins","opName":"DROP 
TABLE","opId":"5767112858332466","opStatus":"START"}
2019-11-01 03:46:39 AUDIT audit:93 - {"time":"October 31, 2019 8:46:39 PM 
PDT","username":"jenkins","opName":"DROP 
TABLE","opId":"5767112858332466","opStatus":"SUCCESS","opTime":"78 
ms","table":"default.origin_table","extraInfo":{}}
- ExternalTableExample

Data:
0       robot0  0       0       9223372036854775807     0.0     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
1       robot1  1       1       9223372036854775806     0.5     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
2       robot2  2       2       9223372036854775805     1.0     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
3       robot3  3       3       9223372036854775804     1.5     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
4       robot4  4       4       9223372036854775803     2.0     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
5       robot5  5       5       9223372036854775802     2.5     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
6       robot6  6       6       9223372036854775801     3.0     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
7       robot7  7       7       9223372036854775800     3.5     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
8       robot8  8       8       9223372036854775799     4.0     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 
9       robot9  9       9       9223372036854775798     4.5     true    
2019-03-01      2019-02-12 03:03:34.0   12.35   varchar 
Hello World From Carbon 

Data:
0       robot0  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         0       0       9223372036854775807     0.0     true    
12.35   
1       robot1  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         1       1       9223372036854775806     0.5     true    
12.35   
2       robot2  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         2       2       9223372036854775805     1.0     true    
12.35   
3       robot3  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         3       3       9223372036854775804     1.5     true    
12.35   
4       robot4  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         4       4       9223372036854775803     2.0     true    
12.35   
5       robot5  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         5       5       9223372036854775802     2.5     true    
12.35   
6       robot6  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         6       6       9223372036854775801     3.0     true    
12.35   
7       robot7  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         7       7       9223372036854775800     3.5     true    
12.35   
8       robot8  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         8       8       9223372036854775799     4.0     true    
12.35   
9       robot9  2019-03-01      2019-02-12 03:03:34.0   varchar Hello World 
From Carbon         9       9       9223372036854775798     4.5     true    
12.35   
- CarbonReaderExample
Running SQL on carbon files directly
+------+---+------+
|  name|age|height|
+------+---+------+
|robot0|  0|   0.0|
|robot1|  1|   0.5|
|robot2|  2|   1.0|
|robot3|  3|   1.5|
|robot4|  4|   2.0|
|robot5|  5|   2.5|
|robot6|  6|   3.0|
|robot7|  7|   3.5|
|robot8|  8|   4.0|
|robot9|  9|   4.5|
+------+---+------+

- DirectSQLExample
2019-11-01 03:46:39 AUDIT audit:72 - {"time":"October 31, 2019 8:46:39 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767113419474229","opStatus":"START"}
2019-11-01 03:46:40 AUDIT audit:93 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767113419474229","opStatus":"SUCCESS","opTime":"48 
ms","table":"default.hive_carbon_example","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":""}}
2019-11-01 03:46:40 AUDIT audit:72 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767113573649186","opStatus":"START"}
2019-11-01 03:46:40 AUDIT audit:93 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767113573649186","opStatus":"SUCCESS","opTime":"145 
ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"0","DataSize":"924.0B","IndexSize":"554.0B"}}
2019-11-01 03:46:40 AUDIT audit:72 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767113730476146","opStatus":"START"}
2019-11-01 03:46:40 AUDIT audit:93 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767113730476146","opStatus":"SUCCESS","opTime":"129 
ms","table":"default.hive_carbon_example","extraInfo":{"SegmentId":"1","DataSize":"924.0B","IndexSize":"554.0B"}}
+---+---------+--------+
| id|     name|  salary|
+---+---------+--------+
|  1|  'liang'|200000.0|
|  2|'anubhav'| 20000.0|
|  1|  'liang'|200000.0|
|  2|'anubhav'| 20000.0|
+---+---------+--------+

2019-11-01 03:46:40 AUDIT audit:72 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767113966489053","opStatus":"START"}
2019-11-01 03:46:40 AUDIT audit:93 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"CREATE 
TABLE","opId":"5767113966489053","opStatus":"SUCCESS","opTime":"53 
ms","table":"default.test_boundary","extraInfo":{"bad_record_path":"","local_dictionary_enable":"true","external":"false","sort_columns":"","comment":"","dictionary_include":"c6_timestamp"}}
2019-11-01 03:46:40 AUDIT audit:72 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767114024408908","opStatus":"START"}
2019-11-01 03:46:40 ERROR DataLoadExecutor:55 - Data Load is partially success 
for table test_boundary
2019-11-01 03:46:40 AUDIT audit:93 - {"time":"October 31, 2019 8:46:40 PM 
PDT","username":"jenkins","opName":"LOAD 
DATA","opId":"5767114024408908","opStatus":"SUCCESS","opTime":"245 
ms","table":"default.test_boundary","extraInfo":{"SegmentId":"0","DataSize":"4.03KB","IndexSize":"1.06KB"}}
OK
******Total Number Of Rows Fetched ****** 0
- HiveExample *** FAILED ***
  java.lang.AssertionError: assertion failed
  at scala.Predef$.assert(Predef.scala:156)
  at 
org.apache.carbondata.examples.HiveExample$.readFromHive(HiveExample.scala:171)
  at 
org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply$mcV$sp(RunExamples.scala:135)
  at 
org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at 
org.apache.carbondata.examplesCI.RunExamples$$anonfun$21.apply(RunExamples.scala:133)
  at 
org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
  at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
  at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
  at org.scalatest.Transformer.apply(Transformer.scala:22)
  at org.scalatest.Transformer.apply(Transformer.scala:20)
  ...
Exception encountered when invoking run on a nested suite - Cannot call 
methods on a stopped SparkContext.
This stopped SparkContext was created at:

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

The currently active SparkContext was created at:

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

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

The currently active SparkContext was created at:

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

Reply via email to