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
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
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 = ? A
t 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>> wrote:
> Er, I also
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>>
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
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
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 appro
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.