[jira] [Created] (CARBONDATA-586) Create table with 'Char' data type but it workes as 'String' data type

2017-01-02 Thread Anurag Srivastava (JIRA)
Anurag Srivastava created CARBONDATA-586: Summary: Create table with 'Char' data type but it workes as 'String' data type Key: CARBONDATA-586 URL: https://issues.apache.org/jira/browse/CARBONDATA-586

[GitHub] incubator-carbondata-site issue #5: Document Changes and Optimization

2017-01-02 Thread chenliang613
Github user chenliang613 commented on the issue: https://github.com/apache/incubator-carbondata-site/pull/5 please rebase and solve the conflict. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not ha

Re: how to make carbon run faster

2017-01-02 Thread 北斗七
17/01/03 15:20:17 STATISTIC QueryStatisticsRecorderImpl: Time taken for Carbon Optimizer to optimize: 2 17/01/03 15:20:23 STATISTIC DriverQueryStatisticsRecorderImpl: Print query statistic for query id: 6047652460423237 +++-++

Re: Dictionary file is locked for Updation, unable to Load

2017-01-02 Thread Harsh Sharma
Hello Team, I am worked on the following scenario, - Created a hive table *hivetest*, - Created a carbon table *employeedemo*, - Loaded some records into hive table with load query, - Executed the insert query on carbon table to load the records from the hive table as below, *inser

?????? how to make carbon run faster

2017-01-02 Thread Jay
in carbon.properties, set enable.query.statistics=true, then the query detail can be get, and then u can check. regards Jay -- -- ??: "??";; : 2017??1??3??(??) 12:15 ??: "dev"; : Re: how to make carbon run faster i

Dictionary file is locked for Updation, unable to Load

2017-01-02 Thread Pallavi Singh
Hi all, On the execution of the following query : LOAD DATA inpath 'hdfs://localhost:54310/csv/test.csv' INTO table employee options('DELIMITER'=',', 'FILEHEADER'='id, firstname'); the table schema is a following : -+ col_name data_type comment --

Re: how to make carbon run faster

2017-01-02 Thread 北斗七
is has a way ,to show carbon use index info,scan nums of lows, used time ,i use like multier index filter may be quicker,like a_id =1 and b_id=2 and c_id=3 and day='2017-01-01' ,the same to orc sql, day is used partition,but *_id not has index, but orc is faster or near equal.i thank this case ,c

?????? how to make carbon run faster

2017-01-02 Thread Jay
hi, beidou 1. the amount of your data is 36GB, for 1 GB 1 block, 40 cores is enough, but i think every task may takes too long time, so i suggest to increase parallelism(for example, change --executor-cores 1 to 5) then enable.blocklet.distribution=true may make more effect.

Re: how to make carbon run faster

2017-01-02 Thread 北斗七
1. You can add the date as filter condition also, for example : select * from test_carbon where status = xx (give a specific value) and date(a.create_time)>= '2016-11-01' and date(a.create_time)<= > '2016-12-26'. this case test before , slow than orc What are your exact business cases? Partitio

Re: 回复: Dictionary file is locked for updation

2017-01-02 Thread Pallavi Singh
Hi all, raised a jira issue : https://issues.apache.org/jira/browse/CARBONDATA-585 On the execution of the following query : LOAD DATA inpath 'hdfs://localhost:54310/csv/test.csv' INTO table employee options('DELIMITER'=',', 'FILEHEADER'='id, firstname'); the table schema is a following : -

[jira] [Created] (CARBONDATA-585) Dictionary file is locked for Updation

2017-01-02 Thread Pallavi Singh (JIRA)
Pallavi Singh created CARBONDATA-585: Summary: Dictionary file is locked for Updation Key: CARBONDATA-585 URL: https://issues.apache.org/jira/browse/CARBONDATA-585 Project: CarbonData Iss

Re: how to make carbon run faster

2017-01-02 Thread Liang Chen
1. You can add the date as filter condition also, for example : select * from test_carbon where status = xx (give a specific value) and date(a.create_time)>= '2016-11-01' and date(a.create_time)<= > '2016-12-26'. What are your exact business cases? Partition and indexes both are good way to impr

[jira] [Created] (CARBONDATA-583) Replace Function is not working for string/char

2017-01-02 Thread Anurag Srivastava (JIRA)
Anurag Srivastava created CARBONDATA-583: Summary: Replace Function is not working for string/char Key: CARBONDATA-583 URL: https://issues.apache.org/jira/browse/CARBONDATA-583 Project: Carbon

[jira] [Created] (CARBONDATA-584) no exception when table name is empty when using bucketing in table using carbon source

2017-01-02 Thread anubhav tarar (JIRA)
anubhav tarar created CARBONDATA-584: Summary: no exception when table name is empty when using bucketing in table using carbon source Key: CARBONDATA-584 URL: https://issues.apache.org/jira/browse/CARBONDATA-

[GitHub] incubator-carbondata-site pull request #5: Document Changes and Optimization

2017-01-02 Thread sgururajshetty
GitHub user sgururajshetty opened a pull request: https://github.com/apache/incubator-carbondata-site/pull/5 Document Changes and Optimization The parameter updated. Website optimized for linking You can merge this pull request into a Git repository by running: $ git pull h