[jira] [Created] (CARBONDATA-929) adding optional field number of blocklet in the carbonindex file

2017-04-14 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-929:
---

 Summary: adding optional field number of blocklet in the 
carbonindex file 
 Key: CARBONDATA-929
 URL: https://issues.apache.org/jira/browse/CARBONDATA-929
 Project: CarbonData
  Issue Type: Improvement
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


The num_blocklet needed to get the number of Blocklet within a block at the 
driver
{code}
 /**
 *  Block index information stored in index file for every block
 */
struct BlockIndex{
  1: required i64 num_rows; // Total number of rows in this file
  2: required string file_name; // Block file name
  3: required i64 offset; // Offset of the footer
  4: required carbondata.BlockletIndex block_index; // Blocklet index
  5: optional i32 num_blocklet; // total number of Blocklet
}

{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Created] (CARBONDATA-913) dead lock problem in unsafe batch parallel read merge sort

2017-04-12 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-913:
---

 Summary: dead lock problem in unsafe batch parallel read merge sort
 Key: CARBONDATA-913
 URL: https://issues.apache.org/jira/browse/CARBONDATA-913
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan
Priority: Critical






--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Created] (CARBONDATA-890) For Spark 2.1 LRU cache size at driver is getting configured with the executor lru cache size.

2017-04-09 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-890:
---

 Summary: For Spark 2.1 LRU cache size at driver is getting 
configured with the executor lru cache size.
 Key: CARBONDATA-890
 URL: https://issues.apache.org/jira/browse/CARBONDATA-890
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan






--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Created] (CARBONDATA-814) bad record log file writing is not correct

2017-03-23 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-814:
---

 Summary: bad record log file writing is not correct
 Key: CARBONDATA-814
 URL: https://issues.apache.org/jira/browse/CARBONDATA-814
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan






--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Created] (CARBONDATA-784) Make configurable empty data to be treated as bad record or not And Expose BAD_RECORDS_ACTION default value to be configurable from out side.

2017-03-16 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-784:
---

 Summary: Make configurable empty data to be treated as bad record 
or not And Expose BAD_RECORDS_ACTION default value to be configurable from out 
side.
 Key: CARBONDATA-784
 URL: https://issues.apache.org/jira/browse/CARBONDATA-784
 Project: CarbonData
  Issue Type: Improvement
  Components: data-load
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


*Make configurable empty data to be treated as bad record or not And Expose 
BAD_RECORDS_ACTION default value to be configurable from out side.*

1. Currently carbon Empty data is considered as bad record.
A property in the load option should be provided so as
the user can tell weather to consider empty data as bad record or not.
*IS_EMPTY_DATA_BAD_RECORD = false/true*
*default to false *
For example if IS_EMPTY_DATA_BAD_RECORD false below data will not treated as 
bad record vice versa
"","",""
,,

*2.Expose BAD_RECORDS_ACTION default value to be configurable from out side. *
A property carbon.bad.records.action will be added in carbon properties 
so that user can configure default value of BAD_RECORDS_ACTION.
*default to FAIL*




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)


[jira] [Created] (CARBONDATA-669) org.apache.carbondata.spark.testsuite.allqueries.InsertIntoCarbonTableTestCase.insert into carbon table from carbon table union query random test failure

2017-01-20 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-669:
---

 Summary: 
org.apache.carbondata.spark.testsuite.allqueries.InsertIntoCarbonTableTestCase.insert
 into carbon table from carbon table union query  random test failure
 Key: CARBONDATA-669
 URL: https://issues.apache.org/jira/browse/CARBONDATA-669
 Project: CarbonData
  Issue Type: Bug
  Components: data-query
Affects Versions: 1.0.0-incubating
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan
 Fix For: 1.0.0-incubating


org.apache.carbondata.spark.testsuite.allqueries.InsertIntoCarbonTableTestCase.insert
 into carbon table from carbon table union query  random test failure

ERROR 19-01 19:49:53,151 - Exception in task 1.0 in stage 1634.0 (TID 7523)
java.lang.NullPointerException
at 
org.apache.carbondata.core.scan.executor.impl.AbstractQueryExecutor.initQuery(AbstractQueryExecutor.java:136)
at 
org.apache.carbondata.core.scan.executor.impl.AbstractQueryExecutor.getBlockExecutionInfos(AbstractQueryExecutor.java:219)
at 
org.apache.carbondata.core.scan.executor.impl.DetailQueryExecutor.execute(DetailQueryExecutor.java:39)
at 
org.apache.carbondata.hadoop.CarbonRecordReader.initialize(CarbonRecordReader.java:79)
at 
org.apache.carbondata.spark.rdd.CarbonScanRDD.compute(CarbonScanRDD.scala:192)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:270)
at 
org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:270)
at 
org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:270)
at org.apache.spark.rdd.UnionRDD.compute(UnionRDD.scala:87)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:270)
at 
org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:270)
at 
org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)
at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:306)
at org.apache.spark.rdd.RDD.iterator(RDD.scala:270)
at 
org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:73)
at 
org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:41)
at org.apache.spark.scheduler.Task.run(Task.scala:89)
at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:227)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
ERROR 19-01 19:49:53,152 - Task 1 in stage 1634.0 failed 1 times; aborting job



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-484) LRU cache for B-Tree to ensure to avoid out memory, when too many number of tables exits and all are not frequently used.

2016-12-02 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-484:
---

 Summary: LRU cache for B-Tree to ensure to avoid out memory, when 
too many number of tables exits and all are not frequently used.
 Key: CARBONDATA-484
 URL: https://issues.apache.org/jira/browse/CARBONDATA-484
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


*LRU Cache for B-Tree*
Problem:

CarbonData is maintaining two level of B-Tree cache, one at the driver level 
and another at executor level.  Currently CarbonData has the mechanism to 
invalidate the segments and blocks cache for the invalid table segments, but 
there is no eviction policy for the unused cached object. So the instance at 
which complete memory is utilized then the system will not be able to process 
any new requests.

Solution:

In the cache maintained at the driver level and at the executor there must be 
objects in cache currently not in use. Therefore system should have the 
mechanism to below mechanism.

1.   Set the max memory limit till which objects could be hold in the 
memory.

2.   When configured memory limit reached then identify the cached objects 
currently not in use so that the required memory could be freed without 
impacting the existing process.

3.   Eviction should be done only till the required memory is not meet.

For details please refer to attachments.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-341) CarbonTableIdentifier being passed to the query flow has wrong tableid

2016-10-27 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-341:
---

 Summary: CarbonTableIdentifier being passed to the query flow has 
wrong tableid
 Key: CARBONDATA-341
 URL: https://issues.apache.org/jira/browse/CARBONDATA-341
 Project: CarbonData
  Issue Type: Bug
  Components: data-query, hadoop-integration, spark-integration
Affects Versions: 0.1.0-incubating
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


CarbonTableIdentifier being passed to the query flow has wrong tableid.
While creating the table the CarbonData system assign a uniqueID to the table. 
In all the places CarbonTableIdentifier  should have the same tableId.
But CarbonTableIdentifier  is having the currentTimeStamp as tableId which is 
not correct. 




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-316) Change BAD_RECORDS_LOGGER_ACTION to BAD_RECORDS_ACTION

2016-10-13 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-316:
---

 Summary: Change BAD_RECORDS_LOGGER_ACTION to BAD_RECORDS_ACTION
 Key: CARBONDATA-316
 URL: https://issues.apache.org/jira/browse/CARBONDATA-316
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan
Priority: Trivial






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-288) In hdfs bad record logger is failing in writting the bad records

2016-10-08 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-288:
---

 Summary: In hdfs bad record logger is failing in writting the bad 
records
 Key: CARBONDATA-288
 URL: https://issues.apache.org/jira/browse/CARBONDATA-288
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


For HDFS file system 
CarbonFile logFile = FileFactory.getCarbonFile(filePath, FileType.HDFS);
if filePath does not exits then
Calling CarbonFile.getPath() throws NullPointerException.
Solution:
If file does not exist then file must be created first.






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-233) bad record logger support for non parsebale numeric and timestamp data

2016-09-11 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-233:
---

 Summary: bad record logger support for non parsebale numeric and 
timestamp data
 Key: CARBONDATA-233
 URL: https://issues.apache.org/jira/browse/CARBONDATA-233
 Project: CarbonData
  Issue Type: Improvement
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


bad record logger support for non parsebale numeric and timestamp data



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-220) TimeStampDirectDictionaryGenerator_UT.java is not running in the build

2016-09-07 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-220:
---

 Summary: TimeStampDirectDictionaryGenerator_UT.java is not running 
in the build
 Key: CARBONDATA-220
 URL: https://issues.apache.org/jira/browse/CARBONDATA-220
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


TimeStampDirectDictionaryGenerator_UT.java is not running in the build.
And generateDirectSurrogateKey test is failing.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-195) Select query with AND filter failing for empty '' operand value of numeric column

2016-08-31 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-195:
---

 Summary: Select query with AND filter failing for empty '' operand 
value of numeric column
 Key: CARBONDATA-195
 URL: https://issues.apache.org/jira/browse/CARBONDATA-195
 Project: CarbonData
  Issue Type: Bug
Affects Versions: 0.1.0-incubating
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


Select query with AND filter failing for empty '' operand value of numeric 
column
Query Syntax:
select * from Table Int_col='' and str_col='';

Throwing ClassCastException



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-183) Blocks are allocated to single node when Executors configured is based on the ip address.

2016-08-26 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-183:
---

 Summary: Blocks are allocated to single node when Executors 
configured is based on the ip address.
 Key: CARBONDATA-183
 URL: https://issues.apache.org/jira/browse/CARBONDATA-183
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-177) Greater than and Less than filter returning wrong result

2016-08-24 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-177:
---

 Summary: Greater than and Less than filter returning wrong result
 Key: CARBONDATA-177
 URL: https://issues.apache.org/jira/browse/CARBONDATA-177
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


DDL:
  "CREATE TABLE IF NOT EXISTS carbonTable(date Timestamp, country String, 
salary Int) STORED " +
  "BY " +
  "'carbondata'
Data:
2015-7-23 12:07:28,china,15000
2018-7-24 12:07:28,china,15001
2017-7-25 12:07:28,china,15002

Load command:
"LOAD DATA LOCAL INPATH '" + csvFilePath + "' into table carbonTable OPTIONS " +
  "('FILEHEADER'='date,country,salary')"

greather than less than filter not returning correct result



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (CARBONDATA-171) Block distribution not proper when the number of active executors more than the node size

2016-08-23 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-171?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan reassigned CARBONDATA-171:
---

Assignee: Mohammad Shahid Khan

> Block distribution not proper when the number of active executors more than 
> the node size
> -
>
> Key: CARBONDATA-171
> URL: https://issues.apache.org/jira/browse/CARBONDATA-171
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>Priority: Blocker
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CARBONDATA-171) Block distribution not proper when the number of active executors more than the node size

2016-08-23 Thread Mohammad Shahid Khan (JIRA)

[ 
https://issues.apache.org/jira/browse/CARBONDATA-171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15432996#comment-15432996
 ] 

Mohammad Shahid Khan commented on CARBONDATA-171:
-

Secenario:
suppose block size : 10
Node size = 3
Number of executors = 8
then only 6 blocks are allocated remaining 4 blocks lefts un- assigned.


> Block distribution not proper when the number of active executors more than 
> the node size
> -
>
> Key: CARBONDATA-171
> URL: https://issues.apache.org/jira/browse/CARBONDATA-171
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Priority: Blocker
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-171) Block distribution not proper when the number of active executors more than the node size

2016-08-23 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-171:
---

 Summary: Block distribution not proper when the number of active 
executors more than the node size
 Key: CARBONDATA-171
 URL: https://issues.apache.org/jira/browse/CARBONDATA-171
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Priority: Blocker






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CARBONDATA-153) Record count is not matching while loading the data when one data node went down in HA setup

2016-08-09 Thread Mohammad Shahid Khan (JIRA)

[ 
https://issues.apache.org/jira/browse/CARBONDATA-153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15414700#comment-15414700
 ] 

Mohammad Shahid Khan commented on CARBONDATA-153:
-

Raised PR# https://github.com/HuaweiBigData/carbondata/pull/913

> Record count is not matching while loading the data when one data node went 
> down in HA setup
> 
>
> Key: CARBONDATA-153
> URL: https://issues.apache.org/jira/browse/CARBONDATA-153
> Project: CarbonData
>  Issue Type: Bug
> Environment: SUSE11SP3, standalone application with Spark 1.6.2 and 
> Hadoop 2.7.2 version
>Reporter: Krishna Reddy
>Assignee: Mohammad Shahid Khan
>
> Record count is not matching while loading the data when one data node went 
> down in HA setup
> 1. Make HA setup
> 2. Kill one data node
> 3. Load the data for 100 records CSV
> 4. Verify the record count
> Actual Result: Record count is not matching with actual records



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (CARBONDATA-153) Record count is not matching while loading the data when one data node went down in HA setup

2016-08-09 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan reassigned CARBONDATA-153:
---

Assignee: Mohammad Shahid Khan

> Record count is not matching while loading the data when one data node went 
> down in HA setup
> 
>
> Key: CARBONDATA-153
> URL: https://issues.apache.org/jira/browse/CARBONDATA-153
> Project: CarbonData
>  Issue Type: Bug
> Environment: SUSE11SP3, standalone application with Spark 1.6.2 and 
> Hadoop 2.7.2 version
>Reporter: Krishna Reddy
>Assignee: Mohammad Shahid Khan
>
> Record count is not matching while loading the data when one data node went 
> down in HA setup
> 1. Make HA setup
> 2. Kill one data node
> 3. Load the data for 100 records CSV
> 4. Verify the record count
> Actual Result: Record count is not matching with actual records



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Resolved] (CARBONDATA-6) data mismatch between the carbon Table and Hive Table for columns having empty values for non numeric data type

2016-08-08 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-6?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan resolved CARBONDATA-6.
---
Resolution: Implemented

The issue is fixed as part of some other issue.
Now not reproducible, so closing the same. Please re open if needed.

> data mismatch between the carbon Table and Hive Table for columns having 
> empty values for non numeric data type
> ---
>
> Key: CARBONDATA-6
> URL: https://issues.apache.org/jira/browse/CARBONDATA-6
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
> Attachments: withemptycolumns.png
>
>
> csv data: 
> 1,2015-7-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525
> 2,,



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (CARBONDATA-91) Concurrent query returning empty result

2016-08-08 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-91?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan closed CARBONDATA-91.
--
Resolution: Fixed

Fixed as part of PR
https://github.com/HuaweiBigData/carbondata/pull/849

> Concurrent query returning empty result
> ---
>
> Key: CARBONDATA-91
> URL: https://issues.apache.org/jira/browse/CARBONDATA-91
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>Priority: Critical
>
> Enviroment:
> 10 node cluster 
> start 20 concurrent query
> most of the queries return no data.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Resolved] (CARBONDATA-103) Rename CreateCube to CreateTable to correct the audit log of create table commnad

2016-07-25 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan resolved CARBONDATA-103.
-
Resolution: Duplicate

> Rename CreateCube to CreateTable to correct the audit log of create table 
> commnad
> -
>
> Key: CARBONDATA-103
> URL: https://issues.apache.org/jira/browse/CARBONDATA-103
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>Priority: Trivial
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Updated] (CARBONDATA-103) Rename CreateCube to CreateTable to correct the audit log of create table commnad

2016-07-25 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan updated CARBONDATA-103:

Assignee: (was: Mohammad Shahid Khan)

> Rename CreateCube to CreateTable to correct the audit log of create table 
> commnad
> -
>
> Key: CARBONDATA-103
> URL: https://issues.apache.org/jira/browse/CARBONDATA-103
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Priority: Trivial
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-103) Rename CreateCube to CreateTable to correct the audit log of create table commnad

2016-07-25 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-103:
---

 Summary: Rename CreateCube to CreateTable to correct the audit log 
of create table commnad
 Key: CARBONDATA-103
 URL: https://issues.apache.org/jira/browse/CARBONDATA-103
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Priority: Trivial






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (CARBONDATA-103) Rename CreateCube to CreateTable to correct the audit log of create table commnad

2016-07-25 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan reassigned CARBONDATA-103:
---

Assignee: Mohammad Shahid Khan

> Rename CreateCube to CreateTable to correct the audit log of create table 
> commnad
> -
>
> Key: CARBONDATA-103
> URL: https://issues.apache.org/jira/browse/CARBONDATA-103
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>Priority: Trivial
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (CARBONDATA-5) data mismatch between the carbon Table and Hive Table for columns having \N for non numeric data type

2016-07-22 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-5?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan closed CARBONDATA-5.
-
Resolution: Fixed

Fixed as part of 
https://github.com/HuaweiBigData/carbondata/pull/802

> data mismatch between the carbon Table and Hive Table for columns having \N 
> for non numeric data type
> -
>
> Key: CARBONDATA-5
> URL: https://issues.apache.org/jira/browse/CARBONDATA-5
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>
> !https://cloud.githubusercontent.com/assets/17875433/16299601/c56cafa4-3958-11e6-8414-704a0275caea.png!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (CARBONDATA-16) BLOCK distribution in query is not correct in query when number of executors are less than the cluster size.

2016-07-22 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-16?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan closed CARBONDATA-16.
--
Resolution: Fixed

Fixed as part of 
https://github.com/HuaweiBigData/carbondata/pull/787

> BLOCK distribution in query is not correct in query when number of executors 
> are less than the cluster size.
> 
>
> Key: CARBONDATA-16
> URL: https://issues.apache.org/jira/browse/CARBONDATA-16
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>Priority: Critical
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (CARBONDATA-57) BLOCK distribution un wanted wait for the executor node even though the sufficient nodes are available

2016-07-22 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-57?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan closed CARBONDATA-57.
--
Resolution: Fixed

Fixed as part of PR 
https://github.com/HuaweiBigData/carbondata/pull/810

> BLOCK distribution un wanted wait for the executor node even though the 
> sufficient nodes are available
> --
>
> Key: CARBONDATA-57
> URL: https://issues.apache.org/jira/browse/CARBONDATA-57
> Project: CarbonData
>  Issue Type: Bug
>  Components: core
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (CARBONDATA-64) data mismatch between the carbon Table and Hive Table for data having empty lines

2016-07-22 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-64?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan closed CARBONDATA-64.
--
Resolution: Fixed

Fixed as part of PR 
https://github.com/HuaweiBigData/carbondata/pull/831

> data mismatch between the carbon Table and Hive Table for data having empty 
> lines
> -
>
> Key: CARBONDATA-64
> URL: https://issues.apache.org/jira/browse/CARBONDATA-64
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>
> data mismatch between the carbon Table and Hive Table for data having empty 
> lines
> create table if not exists emptyRowCarbonTable (eid string,ename String,sal 
> decimal,presal " +
> "decimal,comm decimal" +
> "(37,37),deptno decimal(18,2),Desc String) STORED BY 
> 'org.apache.carbondata.format'
> LOAD DATA INPATH '$csvFilePath' INTO table emptyRowCarbonTable 
> OPTIONS('DELIMITER'=',','QUOTECHAR'='"','FILEHEADER'='eid,ename,sal,presal,comm,deptno,Desc')
> 1,2015-17-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525
> 2,\N,\N,\N,\N,\N,\N
> 4,,d,,d,d,



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CARBONDATA-91) Concurrent query returning empty result

2016-07-21 Thread Mohammad Shahid Khan (JIRA)

[ 
https://issues.apache.org/jira/browse/CARBONDATA-91?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15387761#comment-15387761
 ] 

Mohammad Shahid Khan commented on CARBONDATA-91:


PR https://github.com/HuaweiBigData/carbondata/pull/849

> Concurrent query returning empty result
> ---
>
> Key: CARBONDATA-91
> URL: https://issues.apache.org/jira/browse/CARBONDATA-91
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>Priority: Critical
>
> Enviroment:
> 10 node cluster 
> start 20 concurrent query
> most of the queries return no data.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-91) Concurrent query returning empty result

2016-07-21 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-91:
--

 Summary: Concurrent query returning empty result
 Key: CARBONDATA-91
 URL: https://issues.apache.org/jira/browse/CARBONDATA-91
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


Enviroment:
10 node cluster 
start 20 concurrent query
most of the queries return no data.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CARBONDATA-64) data mismatch between the carbon Table and Hive Table for data having empty lines

2016-07-18 Thread Mohammad Shahid Khan (JIRA)

[ 
https://issues.apache.org/jira/browse/CARBONDATA-64?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15382077#comment-15382077
 ] 

Mohammad Shahid Khan commented on CARBONDATA-64:


Raised PR #https://github.com/HuaweiBigData/carbondata/pull/831

> data mismatch between the carbon Table and Hive Table for data having empty 
> lines
> -
>
> Key: CARBONDATA-64
> URL: https://issues.apache.org/jira/browse/CARBONDATA-64
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>
> data mismatch between the carbon Table and Hive Table for data having empty 
> lines
> create table if not exists emptyRowCarbonTable (eid string,ename String,sal 
> decimal,presal " +
> "decimal,comm decimal" +
> "(37,37),deptno decimal(18,2),Desc String) STORED BY 
> 'org.apache.carbondata.format'
> LOAD DATA INPATH '$csvFilePath' INTO table emptyRowCarbonTable 
> OPTIONS('DELIMITER'=',','QUOTECHAR'='"','FILEHEADER'='eid,ename,sal,presal,comm,deptno,Desc')
> 1,2015-17-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525
> 2,\N,\N,\N,\N,\N,\N
> 4,,d,,d,d,



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-64) data mismatch between the carbon Table and Hive Table for data having empty lines

2016-07-18 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-64:
--

 Summary: data mismatch between the carbon Table and Hive Table for 
data having empty lines
 Key: CARBONDATA-64
 URL: https://issues.apache.org/jira/browse/CARBONDATA-64
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


data mismatch between the carbon Table and Hive Table for data having empty 
lines

create table if not exists emptyRowCarbonTable (eid string,ename String,sal 
decimal,presal " +
"decimal,comm decimal" +
"(37,37),deptno decimal(18,2),Desc String) STORED BY 
'org.apache.carbondata.format'

LOAD DATA INPATH '$csvFilePath' INTO table emptyRowCarbonTable 
OPTIONS('DELIMITER'=',','QUOTECHAR'='"','FILEHEADER'='eid,ename,sal,presal,comm,deptno,Desc')

1,2015-17-23 00:00:00,china,aaa1,phone197,ASD69643,15000.43525
2,\N,\N,\N,\N,\N,\N

4,,d,,d,d,






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-57) BLOCK distribution un wanted wait for the executor node even though the sufficient nodes are available

2016-07-14 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-57:
--

 Summary: BLOCK distribution un wanted wait for the executor node 
even though the sufficient nodes are available
 Key: CARBONDATA-57
 URL: https://issues.apache.org/jira/browse/CARBONDATA-57
 Project: CarbonData
  Issue Type: Bug
  Components: core
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Closed] (CARBONDATA-14) carbon.cutOffTimestamp and carbon.timegranularity is not added in the carbon.properties.template

2016-07-04 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-14?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan closed CARBONDATA-14.
--
Resolution: Fixed

Fixed as part of PR
https://github.com/HuaweiBigData/carbondata/pull/758

> carbon.cutOffTimestamp and carbon.timegranularity is not added in the 
> carbon.properties.template
> 
>
> Key: CARBONDATA-14
> URL: https://issues.apache.org/jira/browse/CARBONDATA-14
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>
> carbon.cutOffTimestamp and carbon.timegranularity is not added in the 
> carbon.properties.template
> Expected:
> The above property should be available in the carbon.properties.template.
> Actual:
> not present in carbon.properties.template



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-27) filter expression to_date( productdate ) = '2012-12-12' not working

2016-06-29 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-27:
--

 Summary: filter expression to_date( productdate ) = '2012-12-12' 
not working
 Key: CARBONDATA-27
 URL: https://issues.apache.org/jira/browse/CARBONDATA-27
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


Scenario:

CREATE TABLE comb04 (imei string,name string,age int,productdate 
timestamp,enddate timestamp,country string,city string,sale int,num 
double,gamePointId double,level decimal(10,3),score decimal(18,3)) STORED BY 
'org.apache.carbondata.format' tblproperties('DICTIONARY_INCLUDE'='age');

LOAD DATA LOCAL INPATH '$testData' INTO TABLE comb04 options ('DELIMITER'=',', 
'QUOTECHAR'='\"')

data:
imei,name,age,productdate,enddate,country,city,sale,num,gamePointId,level,score
imei0,name0,1,2016-05-02 05:45:49,2016-05-02 
05:45:59,zhejiang,hangzhou,15895877,145,15.692,1025412.235,89
imei1,name1,2,2016-05-03 05:15:49,2016-05-03 
05:25:59,zhejiang,wenzhou,15895237,152,15.529,1025412.854,81
imei1,name1,2,2016-05-03 05:15:49,2016-05-03 
05:25:59,zhejiang,wenzhou,15529,152,15.529,15.529,81





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (CARBONDATA-21) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-21?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan reassigned CARBONDATA-21:
--

Assignee: Mohammad Shahid Khan

> Filter query issue for >, <, <= than filter
> ---
>
> Key: CARBONDATA-21
> URL: https://issues.apache.org/jira/browse/CARBONDATA-21
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>
> 1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
>throwing runtime exception
> 2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
>is including the null values also.
> 3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
>is including the null value 
> Null should not considered in less than filter.
> data:
> empid,ename,sal,deptno,mgr,gender,dob,comm,desc
> 1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
> 2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
> 3,cde,4322,,4,m,,16.996,date_null
> 4,,43243,,5,m,,999.117,string_space
> 5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
> 6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
> 7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
> 8



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Resolved] (CARBONDATA-25) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-25?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan resolved CARBONDATA-25.

Resolution: Fixed

> Filter query issue for >, <, <= than filter
> ---
>
> Key: CARBONDATA-25
> URL: https://issues.apache.org/jira/browse/CARBONDATA-25
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>
> 1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
>throwing runtime exception
> 2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
>is including the null values also.
> 3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
>is including the null value 
> Null should not considered in less than filter.
> create cube command: 
> create table a12(empid String,ename String,sal double,deptno int,mgr 
> string,gender string," +
> "dob timestamp,comm decimal(4,2),desc string) stored by 
> 'org.apache.carbondata.format
> data:
> empid,ename,sal,deptno,mgr,gender,dob,comm,desc
> 1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
> 2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
> 3,cde,4322,,4,m,,16.996,date_null
> 4,,43243,,5,m,,999.117,string_space
> 5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
> 6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
> 7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
> 8



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-26) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-26:
--

 Summary: Filter query issue for >, <, <= than filter
 Key: CARBONDATA-26
 URL: https://issues.apache.org/jira/browse/CARBONDATA-26
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
   throwing runtime exception
2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
   is including the null values also.
3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
   is including the null value 
Null should not considered in less than filter.

create cube command: 
create table a12(empid String,ename String,sal double,deptno int,mgr 
string,gender string," +
"dob timestamp,comm decimal(4,2),desc string) stored by 
'org.apache.carbondata.format
data:
empid,ename,sal,deptno,mgr,gender,dob,comm,desc
1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
3,cde,4322,,4,m,,16.996,date_null
4,,43243,,5,m,,999.117,string_space
5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
8






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-25) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-25:
--

 Summary: Filter query issue for >, <, <= than filter
 Key: CARBONDATA-25
 URL: https://issues.apache.org/jira/browse/CARBONDATA-25
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
   throwing runtime exception
2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
   is including the null values also.
3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
   is including the null value 
Null should not considered in less than filter.

create cube command: 
create table a12(empid String,ename String,sal double,deptno int,mgr 
string,gender string," +
"dob timestamp,comm decimal(4,2),desc string) stored by 
'org.apache.carbondata.format
data:
empid,ename,sal,deptno,mgr,gender,dob,comm,desc
1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
3,cde,4322,,4,m,,16.996,date_null
4,,43243,,5,m,,999.117,string_space
5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
8






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-24) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-24:
--

 Summary: Filter query issue for >, <, <= than filter
 Key: CARBONDATA-24
 URL: https://issues.apache.org/jira/browse/CARBONDATA-24
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
   throwing runtime exception
2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
   is including the null values also.
3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
   is including the null value 
Null should not considered in less than filter.

create cube command: 
create table a12(empid String,ename String,sal double,deptno int,mgr 
string,gender string," +
"dob timestamp,comm decimal(4,2),desc string) stored by 
'org.apache.carbondata.format
data:
empid,ename,sal,deptno,mgr,gender,dob,comm,desc
1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
3,cde,4322,,4,m,,16.996,date_null
4,,43243,,5,m,,999.117,string_space
5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
8






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-23) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-23:
--

 Summary: Filter query issue for >, <, <= than filter
 Key: CARBONDATA-23
 URL: https://issues.apache.org/jira/browse/CARBONDATA-23
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
   throwing runtime exception
2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
   is including the null values also.
3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
   is including the null value 
Null should not considered in less than filter.

create cube command: 
create table a12(empid String,ename String,sal double,deptno int,mgr 
string,gender string," +
"dob timestamp,comm decimal(4,2),desc string) stored by 
'org.apache.carbondata.format
data:
empid,ename,sal,deptno,mgr,gender,dob,comm,desc
1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
3,cde,4322,,4,m,,16.996,date_null
4,,43243,,5,m,,999.117,string_space
5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
8






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-22) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-22:
--

 Summary: Filter query issue for >, <, <= than filter
 Key: CARBONDATA-22
 URL: https://issues.apache.org/jira/browse/CARBONDATA-22
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
   throwing runtime exception
2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
   is including the null values also.
3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
   is including the null value 
Null should not considered in less than filter.

create cube command: 
create table a12(empid String,ename String,sal double,deptno int,mgr 
string,gender string," +
"dob timestamp,comm decimal(4,2),desc string) stored by 
'org.apache.carbondata.format
data:
empid,ename,sal,deptno,mgr,gender,dob,comm,desc
1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
3,cde,4322,,4,m,,16.996,date_null
4,,43243,,5,m,,999.117,string_space
5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
8






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-21) Filter query issue for >, <, <= than filter

2016-06-29 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-21:
--

 Summary: Filter query issue for >, <, <= than filter
 Key: CARBONDATA-21
 URL: https://issues.apache.org/jira/browse/CARBONDATA-21
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


1. select count(*) from a12 where dob > '2014-07-01 12:07:28'
   throwing runtime exception
2. select count(*) from a12 where dob < '2014-07-01 12:07:28'
   is including the null values also.
3. select count(*) from a12 where dob <=  '2014-07-01 12:07:28'
   is including the null value 
Null should not considered in less than filter.

data:
empid,ename,sal,deptno,mgr,gender,dob,comm,desc
1,abc,1233,10,2,,2014-07-01 12:07:28,1234.191,string_null
2,bcd,1322,,3,f,2014-07-01 12:07:28,19.99,int_null
3,cde,4322,,4,m,,16.996,date_null
4,,43243,,5,m,,999.117,string_space
5,,43242,20,6,m,2017-07-01 12:07:28,99.999,string_null
6,ijk,,20,6,m,2017-07-01 12:07:28,50089,double_null
7,pqr,2422,20,6,m,2017-07-01 12:07:28,32.339,decimal_null
8






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (CARBONDATA-16) BLOCK distribution in query is not correct in query when number of executors are less than the cluster size.

2016-06-27 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-16?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan reassigned CARBONDATA-16:
--

Assignee: Mohammad Shahid Khan

> BLOCK distribution in query is not correct in query when number of executors 
> are less than the cluster size.
> 
>
> Key: CARBONDATA-16
> URL: https://issues.apache.org/jira/browse/CARBONDATA-16
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>Priority: Critical
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-15) filter query throwing error if the query applied over a table having no data.

2016-06-27 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-15:
--

 Summary: filter query throwing error if the query applied over a 
table having no data.
 Key: CARBONDATA-15
 URL: https://issues.apache.org/jira/browse/CARBONDATA-15
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan
Assignee: Mohammad Shahid Khan


Steps:
1. Create carbon table
2. do not load any data
3. do filter query for ex. select * from table where column_1='shahid';

Actual
throwing 
RuntimeExecption: Exception Occured in query execution.

Expected:
Query should be successful with empty data.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Assigned] (CARBONDATA-14) carbon.cutOffTimestamp and carbon.timegranularity is not added in the carbon.properties.template

2016-06-27 Thread Mohammad Shahid Khan (JIRA)

 [ 
https://issues.apache.org/jira/browse/CARBONDATA-14?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Mohammad Shahid Khan reassigned CARBONDATA-14:
--

Assignee: Mohammad Shahid Khan

> carbon.cutOffTimestamp and carbon.timegranularity is not added in the 
> carbon.properties.template
> 
>
> Key: CARBONDATA-14
> URL: https://issues.apache.org/jira/browse/CARBONDATA-14
> Project: CarbonData
>  Issue Type: Bug
>Reporter: Mohammad Shahid Khan
>Assignee: Mohammad Shahid Khan
>
> carbon.cutOffTimestamp and carbon.timegranularity is not added in the 
> carbon.properties.template
> Expected:
> The above property should be available in the carbon.properties.template.
> Actual:
> not present in carbon.properties.template



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Created] (CARBONDATA-5) data mismatch between the carbon Table and Hive Table for columns having \N for non numeric data type

2016-06-23 Thread Mohammad Shahid Khan (JIRA)
Mohammad Shahid Khan created CARBONDATA-5:
-

 Summary: data mismatch between the carbon Table and Hive Table for 
columns having \N for non numeric data type
 Key: CARBONDATA-5
 URL: https://issues.apache.org/jira/browse/CARBONDATA-5
 Project: CarbonData
  Issue Type: Bug
Reporter: Mohammad Shahid Khan


!https://cloud.githubusercontent.com/assets/17875433/16299601/c56cafa4-3958-11e6-8414-704a0275caea.png!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)