[jira] [Created] (CARBONDATA-272) Two test case are failing , on second time maven build without 'clean'

2016-09-24 Thread Vinod KC (JIRA)
Vinod KC created CARBONDATA-272:
---

 Summary: Two test case are failing , on second time maven build 
without  'clean'
 Key: CARBONDATA-272
 URL: https://issues.apache.org/jira/browse/CARBONDATA-272
 Project: CarbonData
  Issue Type: Bug
  Components: spark-integration
Reporter: Vinod KC
Priority: Trivial


Two test case are failing , during second time build without mvn clean

eg: > 
1) run : mvn  -Pspark-1.6 -Dspark.version=1.6.2  install
2) After successful build, again run mvn  -Pspark-1.6 -Dspark.version=1.6.2  
install

*** 2 SUITES ABORTED ***
[INFO] 
[INFO] Reactor Summary:
[INFO] 
[INFO] Apache CarbonData :: Parent  SUCCESS [ 11.412 s]
[INFO] Apache CarbonData :: Common  SUCCESS [  5.585 s]
[INFO] Apache CarbonData :: Format  SUCCESS [  7.079 s]
[INFO] Apache CarbonData :: Core .. SUCCESS [ 15.874 s]
[INFO] Apache CarbonData :: Processing  SUCCESS [ 12.417 s]
[INFO] Apache CarbonData :: Hadoop  SUCCESS [ 17.330 s]
[INFO] Apache CarbonData :: Spark . FAILURE [07:47 min]
[INFO] Apache CarbonData :: Assembly .. SKIPPED
[INFO] Apache CarbonData :: Examples .. SKIPPED
[INFO] 
[INFO] BUILD FAILURE
[INFO] 


Reason for failure is that two tables created by test cases 
AllDataTypesTestCaseAggregate and NO_DICTIONARY_COL_TestCase are not dropping 
tables properly.


Refer error below error log

- skip auto identify high cardinality column for column group
AllDataTypesTestCaseAggregate:
ERROR 24-09 08:31:29,368 - Table alldatatypescubeAGG not found: 
default.alldatatypescubeAGG table not found
AUDIT 24-09 08:31:29,383 - [vinod][vinod][Thread-1]Creating Table with Database 
name [default] and Table name [alldatatypestableagg]
AUDIT 24-09 08:31:29,385 - [vinod][vinod][Thread-1]Table creation with Database 
name [default] and Table name [alldatatypestableagg] failed. Table 
[alldatatypestableagg] already exists under database [default]
ERROR 24-09 08:31:29,401 - Table Desc1 not found: default.Desc1 table not found
ERROR 24-09 08:31:29,414 - Table Desc2 not found: default.Desc2 table not found
AUDIT 24-09 08:31:29,422 - [vinod][vinod][Thread-1]Creating Table with Database 
name [default] and Table name [desc1]
Exception encountered when invoking run on a nested suite - Table 
[alldatatypestableagg] already exists under database [default] *** ABORTED 
***
  java.lang.RuntimeException: Table [alldatatypestableagg] already exists 
under database [default]
  at scala.sys.package$.error(package.scala:27)
  at 
org.apache.spark.sql.execution.command.CreateTable.run(carbonTableSchema.scala:853)
  at 
org.apache.spark.sql.execution.ExecutedCommand.sideEffectResult$lzycompute(commands.scala:58)
  at 
org.apache.spark.sql.execution.ExecutedCommand.sideEffectResult(commands.scala:56)
  at 
org.apache.spark.sql.execution.ExecutedCommand.doExecute(commands.scala:70)
  at 
org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$5.apply(SparkPlan.scala:132)
  at 
org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$5.apply(SparkPlan.scala:130)
  at 
org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:150)
  at 
org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:130)
  at 
org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:55)
  ...



[32mNO_DICTIONARY_COL_TestCase:
ERROR 24-09 08:31:29,954 - Table filtertestTables not found: 
default.filtertestTables table not found
AUDIT 24-09 08:31:30,041 - [vinod][vinod][Thread-1]Deleting table 
[no_dictionary_carbon_6] under database [default]
AUDIT 24-09 08:31:30,115 - [vinod][vinod][Thread-1]Deleted table 
[no_dictionary_carbon_6] under database [default]
AUDIT 24-09 08:31:30,122 - [vinod][vinod][Thread-1]Deleting table 
[no_dictionary_carbon_7] under database [default]
AUDIT 24-09 08:31:30,191 - [vinod][vinod][Thread-1]Deleted table 
[no_dictionary_carbon_7] under database [default]
AUDIT 24-09 08:31:30,454 - [vinod][vinod][Thread-1]Creating Table with Database 
name [default] and Table name [no_dictionary_carbon_6]
AUDIT 24-09 08:31:30,480 - [vinod][vinod][Thread-1]Table created with Database 
name [default] and Table name [no_dictionary_carbon_6]
AUDIT 24-09 08:31:30,583 - [vinod][vinod][Thread-1]Data load request has been 
received for table default.no_dictionary_carbon_6
AUDIT 24-09 08:31:30,665 - 

[Discussion] Support Date/Time format for Timestamp columns to be defined at column level

2016-09-24 Thread 向志强
Hi, all

In recent days, I am trying to handle issues CARBONDATA-37. We are trying
to support that Date format can be set at column level.

There is a doubt that we should feedback the the same format for Date
column or feedback a uniform format. Absolutely.

For example.

we create a table and define two cols which data type is Date. But the Date
format is different.

col1(Date)   col2(Date)
2016-09-24 2016-09-25 00:00:00

when querying, for two formats below, which should be returned?

 col1(Date)   col2(Date)
2016-09-24 2016-09-25 00:00:00

or

 col1(Date) col2(Date)
2016-09-24 00:00:00 2016-09-25 00:00:00

if we set -MM-DD HH:MM:SS as default format.


Best wishes!