Re: Is there a way to specify split num or reducer num when creating phoenix table ?

Sorry,i can’t get your words. when I set SALT_BUCKETS = 256, the region num is actually 256. Pre-split along date-boundaries will be hundreds of split points, it is a heavy work. The biggest problem I’m facing is how to bulkload 1T data to phoenix table. > On Aug 29, 2019, at 8:18 PM, Josh

Re: Is there a way to specify split num or reducer num when creating phoenix table ?

have a chronological series of data. Data row like dt, r1 ,r2 ,r3 ,r4 ,r5 ,r6 ,d1 ,d2 ,d3 ,d4 , d5 … And dt is format as 20190829 , increasing monotonically, such as 20190830,20190831... The query pattern is some like select * from table where dt between 20180620 and 20190829 and r3

Re: !indexes in sqlline shows empty

Awesome , it works , thanks. > On Aug 21, 2019, at 5:35 AM, Vincent Poon wrote: > > try this: > !indexes > > On Tue, Aug 20, 2019 at 12:29 AM you Zhuang > wrote: > > > Does sqlline be not accurate ? > > When I query columns in index , explain plan shows

Is there a way to specify split num or reducer num when creating phoenix table ?

I have a chronological series of data. Data row like dt, r1 ,r2 ,r3 ,r4 ,r5 ,r6 ,d1 ,d2 ,d3 ,d4 , d5 … And dt is format as 20190829 , increasing monotonically, such as 20190830,20190831... The query pattern is some like select * from table where dt between 20180620 and 20190829 and r3

Re: Is there any way to using appropriate index automatically?

Thanks, I will get a try > On Aug 21, 2019, at 5:24 AM, Vincent Poon wrote: > > check out PHOENIX-5109 , it likely fixes your issue. > Unfortunately it's targeted for 4.15.0 which hasn't been released yet. Maybe > you can backport and see if it works for your query. > > On Tue, Aug 20, 2019

Re: Is there any way to using appropriate index automatically?

No, the index can’t be used . > On Aug 21, 2019, at 2:38 AM, Ankit Singhal > wrote: > > CREATE local INDEX local_c_h_index ON test_phoenix.app (c,h) ASYNC; > (Has been filled data with bulkload and index is active) > > Query: > select /*+