[jira] [Commented] (PHOENIX-1643) Add default value for PColumn.getExpressionStr()

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308667#comment-14308667 ] James Taylor commented on PHOENIX-1643: --- Thanks for the patch, [~tdsilva]. Looks v

[jira] [Updated] (PHOENIX-1620) Add API for getting tenant ID from an HBase row of a Phoenix table

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1620: -- Attachment: 1620_v2.patch Working patch with tests. One interesting case to think about is how

[jira] [Updated] (PHOENIX-1643) Add default value for PColumn.getExpressionStr()

2015-02-05 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-1643: Attachment: PHOENIX-1643.patch [~giacomotaylor] I have attached a patch for master/4.3.

[jira] [Created] (PHOENIX-1643) Add default value for PColumn.getExpressionStr()

2015-02-05 Thread Thomas D'Silva (JIRA)
Thomas D'Silva created PHOENIX-1643: --- Summary: Add default value for PColumn.getExpressionStr() Key: PHOENIX-1643 URL: https://issues.apache.org/jira/browse/PHOENIX-1643 Project: Phoenix Is

[jira] [Commented] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308490#comment-14308490 ] James Taylor commented on PHOENIX-1641: --- Yes, that's correct. Good catch. You're r

[jira] [Commented] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308442#comment-14308442 ] Samarth Jain commented on PHOENIX-1641: --- If I am understanding this correctly, is

[jira] [Commented] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308412#comment-14308412 ] James Taylor commented on PHOENIX-1641: --- Sorry, meant MIN_SYSTEM_TABLE_TIMESTAMP.

[jira] [Commented] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308407#comment-14308407 ] Samarth Jain commented on PHOENIX-1641: --- MIN_TABLE_TIMESTAMP is 0. And the current

[jira] [Comment Edited] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308380#comment-14308380 ] James Taylor edited comment on PHOENIX-1641 at 2/6/15 1:07 AM: ---

[jira] [Commented] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308380#comment-14308380 ] James Taylor commented on PHOENIX-1641: --- I think you'd want if (currentTimestamp <

[jira] [Created] (PHOENIX-1642) Make Phoenix Master Branch pointing to HBase1.0.0

2015-02-05 Thread Jeffrey Zhong (JIRA)
Jeffrey Zhong created PHOENIX-1642: -- Summary: Make Phoenix Master Branch pointing to HBase1.0.0 Key: PHOENIX-1642 URL: https://issues.apache.org/jira/browse/PHOENIX-1642 Project: Phoenix Iss

[jira] [Updated] (PHOENIX-900) Partial results for mutations

2015-02-05 Thread Eli Levine (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eli Levine updated PHOENIX-900: --- Attachment: PHOENIX-900.patch Initial attempt. No tests yet. Need to figure out how to simulate parti

[jira] [Commented] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308321#comment-14308321 ] Samarth Jain commented on PHOENIX-1641: --- Here is the history: INDEX_TYPE column w

[jira] [Commented] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308259#comment-14308259 ] James Taylor commented on PHOENIX-1641: --- As [~tdsilva] found out, ALTER TABLE ADD

[jira] [Commented] (PHOENIX-1142) Improve CsvBulkLoadTool to parse different Date formats

2015-02-05 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308246#comment-14308246 ] James Taylor commented on PHOENIX-1142: --- The v2 patch looks much better - thanks f

[jira] [Commented] (PHOENIX-1142) Improve CsvBulkLoadTool to parse different Date formats

2015-02-05 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1142?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308236#comment-14308236 ] Jeffrey Zhong commented on PHOENIX-1142: The v2 patch passed all tests locally.

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

2015-02-05 Thread Mujtaba Chohan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14308178#comment-14308178 ] Mujtaba Chohan commented on PHOENIX-1634: - Thanks @rajeshbabu. I'll check with 0

Re: Data loaded from Hbase is not visible in Phoenix

2015-02-05 Thread Siva
Hi Alicia, Issue is resolved after the changing the column qualifiers to uppercase. here is the response from one of the user Chandu. --- You have to double quotes to get correct mapping from phoenix to hbase columns. Try using the upper case letters for a

Line separator option in Bulk loader

2015-02-05 Thread Siva
We have table contains a NOTE column, this column contains lines of text separated by new lines. When I export the data from .csv through bulkloader, Phoenix is failing with error and Hbase terminates the text till encounters the new line and assumes rest of NOTE as new record. Is there a way to

Re: Data loaded from Hbase is not visible in Phoenix

2015-02-05 Thread Alicia Shu
Data types are enforced by Phoenix. Hbase stores raw data. Can you use ³Upsert² to insert data into the table and make sure type consistency? Then see whether you will see data. Alicia On 2/5/15, 12:34 PM, "Siva" wrote: >Hi Alicia, thanks for you response, but Data types in Hbase are always in

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

2015-02-05 Thread Rajeshbabu Chintaguntla (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14307983#comment-14307983 ] Rajeshbabu Chintaguntla commented on PHOENIX-1634: -- [~mujtabachohan] HB

Re: Data loaded from Hbase is not visible in Phoenix

2015-02-05 Thread Siva
Hi Alicia, thanks for you response, but Data types in Hbase are always in Byte type.. how can we explicitly specify the type information for column qualifiers in Hbase? On Wed, Feb 4, 2015 at 4:33 PM, Alicia Shu wrote: > Make sure the data types you created in Phoenix table are the same as > tho

[jira] [Updated] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-1641: -- Attachment: PHOENIX-1641.patch > Add back the upgrade code in ConnectionQueryServicesImpl > --

[jira] [Created] (PHOENIX-1641) Add back the upgrade code in ConnectionQueryServicesImpl

2015-02-05 Thread Samarth Jain (JIRA)
Samarth Jain created PHOENIX-1641: - Summary: Add back the upgrade code in ConnectionQueryServicesImpl Key: PHOENIX-1641 URL: https://issues.apache.org/jira/browse/PHOENIX-1641 Project: Phoenix

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

2015-02-05 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14307769#comment-14307769 ] Andrew Purtell commented on PHOENIX-1634: - Thanks for the reproduction [~mujtaba

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

2015-02-05 Thread Mujtaba Chohan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan updated PHOENIX-1634: Attachment: performance.py > LocalIndexSplitter prevents region from auto split >

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

2015-02-05 Thread Mujtaba Chohan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mujtaba Chohan updated PHOENIX-1634: Attachment: logs.zip > LocalIndexSplitter prevents region from auto split > --

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

2015-02-05 Thread Mujtaba Chohan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14307765#comment-14307765 ] Mujtaba Chohan commented on PHOENIX-1634: - [~rajesh23] Here is the simple test t

[jira] [Commented] (PHOENIX-1638) Avoid batched mutations via direct use of HRegion

2015-02-05 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14307525#comment-14307525 ] Andrew Purtell commented on PHOENIX-1638: - Region might implement the Table inte

[jira] [Commented] (PHOENIX-1636) Substitute HRegionInfo for HRegion where possible

2015-02-05 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14307522#comment-14307522 ] Andrew Purtell commented on PHOENIX-1636: - When HBASE-12973 is committed do we b

[jira] [Commented] (PHOENIX-1637) Use supported region locking protocols when available

2015-02-05 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14307519#comment-14307519 ] Andrew Purtell commented on PHOENIX-1637: - Also note that should HBase ever supp

Fully qualified tablename query support in Phoenix

2015-02-05 Thread Suraj Misra
Hi, I am using 4.1.0 Phoenix driver and are able to execute queries having fully qualified names in table names. For example: CREATE TABLE *TEST.CUSTOMERS_TEST* (ID INTEGER NOT NULL PRIMARY KEY, NAME VARCHAR(40) NOT NULL, AGE INTEGER NOT NULL, CITY CHAR(25)) UPSERT INTO *TEST.CUSTOMERS_TEST* VAL