[jira] [Updated] (PHOENIX-1634) LocalIndexSplitter prevents region from auto split

[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-1634: - Attachment: PHOENIX-1634.patch We are not adding parent_table key proper

Re: Phoenix monitoring

Thanks Ted. Cheers Pari On 12 February 2015 at 11:38, Ted Yu wrote: > w.r.t. release of 4.3, see this thread: > http://search-hadoop.com/m/lz2la1mCuXS > > Cheers > > On Wed, Feb 11, 2015 at 9:46 PM, Pariksheet Barapatre < > pbarapa...@gmail.com> > wrote: > > > Thanks All for your comments. > >

Re: Phoenix monitoring

w.r.t. release of 4.3, see this thread: http://search-hadoop.com/m/lz2la1mCuXS Cheers On Wed, Feb 11, 2015 at 9:46 PM, Pariksheet Barapatre wrote: > Thanks All for your comments. > > So shall we wait for 4.3 to be available. We are using 4.2 right now and > when we enabled tracing it already cr

Re: Phoenix monitoring

Thanks All for your comments. So shall we wait for 4.3 to be available. We are using 4.2 right now and when we enabled tracing it already crashed down the HBase. Also, what is exact release date of 4.3. Few more doubts from my side - 1) What is best way to upgrade Phoenix. At HBase level, we can

how to force user login use password through phoenix with hbase

Hi all As subject, I met a problem in using phoenix with hbase, when I use phoenix to connect hbase that I don't need to input usename and password. so people who know the host without password can login anywhere. Is there any solution to deal with this problem? Thank you very much!!!

[jira] [Updated] (PHOENIX-1654) Incorrect group-by keys from ClientAggregatePlan

[ https://issues.apache.org/jira/browse/PHOENIX-1654?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-1654: - Attachment: 1654.patch > Incorrect group-by keys from ClientAggregatePlan >

[jira] [Created] (PHOENIX-1654) Incorrect group-by keys from ClientAggregatePlan

Maryann Xue created PHOENIX-1654: Summary: Incorrect group-by keys from ClientAggregatePlan Key: PHOENIX-1654 URL: https://issues.apache.org/jira/browse/PHOENIX-1654 Project: Phoenix Issue Ty

[jira] [Commented] (PHOENIX-1588) TableNotFoundException when optimizing "SELECT * FROM a tenant-specific table"

[ https://issues.apache.org/jira/browse/PHOENIX-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317502#comment-14317502 ] James Taylor commented on PHOENIX-1588: --- Probably best if we try to encapsulate th

[jira] [Commented] (PHOENIX-1580) Support UNION ALL

[ https://issues.apache.org/jira/browse/PHOENIX-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317491#comment-14317491 ] Alicia Ying Shu commented on PHOENIX-1580: -- [~jamestaylor] >Any particular rea

Re: Phoenix monitoring

Hi Rohit, I am interested in knowing more about DSM and its capabilities. I have some questions: 1) Phoenix logs the traces in a Phoenix table. Can a Phoenix table work as a DSM repository? 2) Does DSM expect data to be in a particular format or does it provide a means to plug in you own data pul

Re: [VOTE] Release of Apache Phoenix 4.3.0 RC0

+1 Tested for regressions using a test suite for internal Salesforce use cases with Phoenix binary artifacts from https://dist.apache.org/repos/dist/dev/phoenix/phoenix-4.3.0-rc0/bin/ On Tue, Feb 10, 2015 at 7:25 PM, James Taylor wrote: > Hello everyone, > > This is a call for a vote on Apache

[jira] [Commented] (PHOENIX-1634) LocalIndexSplitter prevents region from auto split

[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317420#comment-14317420 ] Rajeshbabu Chintaguntla commented on PHOENIX-1634: -- I am trying to repr

[jira] [Commented] (PHOENIX-1634) LocalIndexSplitter prevents region from auto split

[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317377#comment-14317377 ] Mujtaba Chohan commented on PHOENIX-1634: - To repro. Steps are even simpler. On

[jira] [Commented] (PHOENIX-1634) LocalIndexSplitter prevents region from auto split

[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317363#comment-14317363 ] Mujtaba Chohan commented on PHOENIX-1634: - I did not move any region for base ta

[jira] [Commented] (PHOENIX-1634) LocalIndexSplitter prevents region from auto split

[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317346#comment-14317346 ] Rajeshbabu Chintaguntla commented on PHOENIX-1634: -- [~mujtabachohan] Wh

[jira] [Reopened] (PHOENIX-1634) LocalIndexSplitter prevents region from auto split

[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan reopened PHOENIX-1634: - [~rajesh23] With *HBase 0.98.10* - Using the same test scenario in which base table is decl

[jira] [Updated] (PHOENIX-1588) TableNotFoundException when optimizing "SELECT * FROM a tenant-specific table"

[ https://issues.apache.org/jira/browse/PHOENIX-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-1588: Attachment: PHOENIX-1588.v2.patch [~maryannxue] I think this is required because the base

Phoenix bulk loading

Hello all, is there a way to specify to keep NULL values for the columns which were not there in csv file as part of bulk loading? Requirement I have is, few row in csv file contains all the column, but rows contain only few columns. In Hbase, if the given record doesnt have desired columns, it

[jira] [Commented] (PHOENIX-1588) TableNotFoundException when optimizing "SELECT * FROM a tenant-specific table"

[ https://issues.apache.org/jira/browse/PHOENIX-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317109#comment-14317109 ] Maryann Xue commented on PHOENIX-1588: -- Thank you for your quick turnaround on this

RE: Phoenix monitoring

Thanks Nick! Yes Data Services Manager (DSM) does provide the kind of perspective Pari is looking for but not for Phoenix. Actually, if Phoenix is providing metrics and information in a repository or via a REST interface, on queries, elapsed times, etc. then certainly it could be incorporated

[jira] [Resolved] (PHOENIX-1517) PArrayDataType#isSizeCompatible not invoked for all array types

[ https://issues.apache.org/jira/browse/PHOENIX-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-1517. --- Resolution: Duplicate Duplicate/encompassed by work in PHOENIX-1514 > PArrayDataType#isSize

[jira] [Updated] (PHOENIX-1372) Fix resource leaks in various classes

[ https://issues.apache.org/jira/browse/PHOENIX-1372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Yu updated PHOENIX-1372: Labels: resources (was: ) > Fix resource leaks in various classes > -

[jira] [Updated] (PHOENIX-1588) TableNotFoundException when optimizing "SELECT * FROM a tenant-specific table"

[ https://issues.apache.org/jira/browse/PHOENIX-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-1588: Attachment: PHOENIX-1588.patch [~maryannxue] The test was failing because the tenant id w

[jira] [Created] (PHOENIX-1653) Allow option to pass peer zookeeper address to load data into a target cluster in Map Reduce api

maghamravikiran created PHOENIX-1653: Summary: Allow option to pass peer zookeeper address to load data into a target cluster in Map Reduce api Key: PHOENIX-1653 URL: https://issues.apache.org/jira/browse/PHOE

[jira] [Commented] (PHOENIX-1652) API or Library in PHP

[ https://issues.apache.org/jira/browse/PHOENIX-1652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14316859#comment-14316859 ] Nick Dimiduk commented on PHOENIX-1652: --- Right now Phoenix is implemented as a "th

[jira] [Commented] (PHOENIX-1517) PArrayDataType#isSizeCompatible not invoked for all array types

[ https://issues.apache.org/jira/browse/PHOENIX-1517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14316856#comment-14316856 ] Nick Dimiduk commented on PHOENIX-1517: --- I think this is fixed by PHOENIX-1514, so

Re: Phoenix monitoring

Agreed tracing will help on a query-by-query basis, but I think we don't have a very good usability story yet. Hence the recommendation of exposing info from JMX into an external system like OpenTSDB or DSM. On Wed, Feb 11, 2015 at 10:45 AM, Samarth Jain wrote: > Hi Pariksheet, > > Phoenix Traci

RE: Phoenix monitoring

JMX interfaces are fine, too. Thank you, Gunnar Download a free version of HPDSM, a unified big-data administration tool for Vertica and Hadoop at: HP DSM Download “People don’t know what they want until you show i

Re: Phoenix monitoring

Hi Pariksheet, Phoenix Tracing might help you here. See: http://phoenix.apache.org/tracing.html With tracing on, you can get information on the the scans being executed - duration of each scan, region server on which it is being executed, query plan etc. All this is logged in the trace table (def

[jira] [Commented] (PHOENIX-1115) Provide a SQL command to turn tracing on/off

[ https://issues.apache.org/jira/browse/PHOENIX-1115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14316603#comment-14316603 ] Jeffrey Zhong commented on PHOENIX-1115: RDBMS does trace in their own ways. In

Re: Phoenix monitoring

Hi Pari, I'm not aware of a Phoenix-aware, end-to-end solution here. You can probably write a custom collector for a Phenox application that can report into OpenTSDB; I think JDBC metrics are available via JMX. That would be a great addition for that project! I've also seen a product demo from HP

[jira] [Commented] (PHOENIX-1561) Pig optimized joins

[ https://issues.apache.org/jira/browse/PHOENIX-1561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14316418#comment-14316418 ] Gabriel Reid commented on PHOENIX-1561: --- I think the patch is good to go as is --

[jira] [Reopened] (PHOENIX-1549) CSV loader doesn't use configured date format for loading dates

[ https://issues.apache.org/jira/browse/PHOENIX-1549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gabriel Reid reopened PHOENIX-1549: --- No, I believe this is still an issue. I'll still need to verify it to be sure (and hopefully fi

[jira] [Commented] (PHOENIX-1539) Unable to Bulk Load into HBase 0.98.8

[ https://issues.apache.org/jira/browse/PHOENIX-1539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14316403#comment-14316403 ] Gabriel Reid commented on PHOENIX-1539: --- A little follow-up on this being resolved

Phoenix monitoring

Hello All, Can you suggest good monitoring tool for phoenix. Our QA hbase cluster is crashing randomly. We wanted to know stats like which query causing the issue and how many queries running on that particular time window, resource consumption of query etc. Cheers Pari

[jira] [Commented] (PHOENIX-1277) CSVCommonsLoader not allowing null CHAR values (non PK)

[ https://issues.apache.org/jira/browse/PHOENIX-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14316375#comment-14316375 ] Gabriel Reid commented on PHOENIX-1277: --- The issue here was for a non-key field, s

[jira] [Assigned] (PHOENIX-1277) CSVCommonsLoader not allowing null CHAR values (non PK)

[ https://issues.apache.org/jira/browse/PHOENIX-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gabriel Reid reassigned PHOENIX-1277: - Assignee: Gabriel Reid > CSVCommonsLoader not allowing null CHAR values (non PK) >

[jira] [Updated] (PHOENIX-1652) API or Library in PHP

[ https://issues.apache.org/jira/browse/PHOENIX-1652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chintan Shah updated PHOENIX-1652: -- Summary: API or Library in PHP (was: API or Library for PHP) > API or Library in PHP > --

[jira] [Created] (PHOENIX-1652) API or Library for PHP

Chintan Shah created PHOENIX-1652: - Summary: API or Library for PHP Key: PHOENIX-1652 URL: https://issues.apache.org/jira/browse/PHOENIX-1652 Project: Phoenix Issue Type: Wish Rep

[jira] [Commented] (PHOENIX-1550) Freeze and thaw Phoenix tables

[ https://issues.apache.org/jira/browse/PHOENIX-1550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14315876#comment-14315876 ] Sun Fulin commented on PHOENIX-1550: Any progress on this issue ? [~apurtell] > Fre