Re: Does index be used when doing "join" operation between a big table and a small table?

2017-10-11 Thread Mic Sun
Except the number of tasks, can we confirm whether to use index from the log file? Such as something like keyword for us to search in the log file directly. - FFCS研究院 -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/

[DISCUSSION] Optimize the default value for some parameters

2017-10-11 Thread Liang Chen
Hi All As you know, some default value of parameters need to adjust for most of cases, this discussion is for collecting which parameters' default value need to be optimized: 1. TABLE_BLOCKSIZE: current default is 1G, propose to adjust to 512M 2. Please append at here if you propose to adjust

Re: Does index be used when doing "join" operation between a big table and a small table?

2017-10-11 Thread Liang Chen
If the index be used, the number of tasks would be less. Can you share your script (create table script and query script), let us check if you created the effective index for filter columns. Regards Liang -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/

Re: Does index be used when doing "join" operation between a big table and a small table?

2017-10-11 Thread Liang Chen
Hi If the index be used for filtering data, the number of tasks would be more less. Can you share the script(create table and query), let us check if created the effective index for filter columns. Regards Liang Mic Sun wrote > hello, > > I have 2 tables need to do "join" operation by their

Re: [DISCUSSION] support user specified segment reading for query

2017-10-11 Thread Liang Chen
Hi Rahul I suggest only doing "Query HINT". Please finalize the query script : select * from t1 [in SEGMENTS(1,3,5)] or SELECT /*+SEGMENTS(1,3,5) */ from t1 Regards Liang -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/

Re: [DISCUSSION] Apache CarbonData 1.3.0 scope

2017-10-11 Thread Liang Chen
Hi yuhai I have same comment as Jacky,please provide more info about this requirement. It would be better if you could create a new topic to detailedly discuss this requirement. Regards Liang Jacky Li wrote > Hi Cenyuhai, > > Can you further describe your requirement? Currently carbon supports