Member since
11-14-2015
268
Posts
122
Kudos Received
29
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2661 | 08-07-2017 08:39 AM | |
4281 | 07-26-2017 06:06 AM | |
9836 | 12-30-2016 08:29 AM | |
7743 | 11-28-2016 08:08 AM | |
7570 | 11-21-2016 02:16 PM |
04-15-2016
03:40 PM
1 Kudo
yes , functions in where clause works perfectly. I think to_char() will be giving epoch with commas
... View more
04-14-2016
12:57 PM
GC pauses are mostly expected when there is frequent eviction from block cache( with un-repeated or large scans loading new blocks in cache everytime, with frequent compaction, with scans on table which is not well distributed across regionservers making one regionserver's cache hot etc. ). PS:- It is not necessary that phoenix always use skip-scan filter for every query for eg:- it will not use it if you don't have leading columns of the rowkey in your "where" clause as it will not know to which key to seek.
... View more
04-13-2016
06:18 PM
1 Kudo
Yes compaction , invalidate the block cache hence results in more GC.
... View more
04-13-2016
08:42 AM
2 Kudos
If you don't have latency sensitive application then you should go ahead and increase it. But I would suggest to tune your GC and do capacity planning as per load. If some nodes are experiencing more GC than others then you might need to check the hot spots and if your query is scanning full table then you might try skipping block cache for that scan.
... View more
04-06-2016
06:44 PM
Thanks @ssoldatov, it worked perfectly
... View more
03-08-2016
10:45 AM
2 Kudos
You may refer below section.
https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table
... View more
02-18-2016
10:31 AM
2 Kudos
It is fixed in phoenix 4.7 version , please find a jira for the same. https://issues.apache.org/jira/browse/PHOENIX-2608 As 4.7 is not yet release so meanwhile you can ask for a hotfix from your vendor.
... View more
02-18-2016
10:31 AM
1 Kudo
It is fixed in phoenix 4.7 version , please find a jira for the same.
https://issues.apache.org/jira/browse/PHOENIX-2608
As 4.7 is not yet release so meanwhile you can ask for a hotfix from your vendor.
... View more
02-18-2016
10:23 AM
3 Kudos
Hi @Harshal Joshi, For large joins , please use sort merge join to avoid memory issues. You just need to pass following hint "/*+ USE_SORT_MERGE_JOIN */" in the query. https://phoenix.apache.org/joins.html
... View more