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: !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 <mailto:zhuangzixiao...@gmail.com>> wrote: > > > Does sqlline be not accurate ? > > When I q

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?

,d,e,f,g,h,i,j,k,m,n from > TEST_PHOENIX.APP where c=2 and h = 1 limit 5", and see if index is getting > used. > > Regards, > Ankit Singhal > > On Tue, Aug 20, 2019 at 1:49 AM you Zhuang <mailto:zhuangzixiao...@gmail.com>> wrote: > Er, I also r

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

also can you try running "select a,b,c,d,e,f,g,h,i,j,k,m,n from > TEST_PHOENIX.APP where c=2 and h = 1 limit 5", and see if index is getting > used. > > Regards, > Ankit Singhal > > On Tue, Aug 20, 2019 at 1:49 AM you Zhuang <mailto:zhuangzixiao...@gmail.com>>

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

ensuring the lookup is local.” I ‘m totally confused. > On Aug 20, 2019, at 12:32 AM, Josh Elser wrote: > > http://phoenix.apache.org/faq.html#Why_isnt_my_secondary_index_being_used > <http://phoenix.apache.org/faq.html#Why_isnt_my_secondary_index_being_used> > > On 8/1

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

he.org/faq.html#Why_isnt_my_secondary_index_being_used> > > On 8/19/19 6:06 AM, you Zhuang wrote: >> Phoenix-version: 4.14.3-HBase-1.4-SNAPSHOT >> hbase-version: 1.4.6 >> Table: >> CREATE TABLE test_phoenix.app ( >> dt integer not null, >> a bigint not null , >> b bi

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

even without hints, if > they're suitable for a query. > Maybe you can share your Phoenix version, query, index definition and exec > plan ? > > On Mon, Aug 19, 2019 at 12:46 PM you Zhuang <mailto:zhuangzixiao...@gmail.com>> wrote: > Yeah, I mean no hint , use appropriat

Is there any way to using appropriate index automatically?

Yeah, I mean no hint , use appropriate index automatically. I create a local index and a query with corresponding index column filter in where clause. But the query doesn’t use index, with index hint it uses it.