Re: Phoenix Pig integration

2015-08-10 Thread Ravi Kiran
Hi Pari, I wrote a quick test and there indeed seems to be an issue when SALT BUCKETS are mentioned on the table. Can you please raise a JIRA ticket. In the mean while, can you try the following to get over the issue. raw = LOAD 'hbase://*query/SELECT CLIENTID,EMPID,NAME FROM HIRES*' USING

[jira] [Commented] (PHOENIX-953) Support UNNEST for ARRAY

2015-08-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680414#comment-14680414 ] James Taylor commented on PHOENIX-953: -- Maybe a good compromise is to support the

[jira] [Commented] (PHOENIX-1791) Pherf - Support data creation to multi-tenant views

2015-08-10 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680454#comment-14680454 ] Hudson commented on PHOENIX-1791: - FAILURE: Integrated in Phoenix-master #869 (See

[jira] [Commented] (PHOENIX-953) Support UNNEST for ARRAY

2015-08-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680377#comment-14680377 ] James Taylor commented on PHOENIX-953: -- This should work: {code} select p from a

[GitHub] phoenix pull request: PHOENIX-1118 : Trace Web Application

2015-08-10 Thread AyolaJayamaha
Github user AyolaJayamaha commented on the pull request: https://github.com/apache/phoenix/pull/103#issuecomment-129547016 ![screenshot from 2015-08-10 19 37 43](https://cloud.githubusercontent.com/assets/1260234/9178646/daae8d8a-3fb5-11e5-89d0-8e3559f7ee50.png) Trace count

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

2015-08-10 Thread Ted Yu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ted Yu updated PHOENIX-1372: Description: Statement / PreparedStatement should be closed after query completes. Below is an example of

[jira] [Commented] (PHOENIX-1118) Provide a tool for visualizing Phoenix tracing information

2015-08-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680437#comment-14680437 ] ASF GitHub Bot commented on PHOENIX-1118: - Github user AyolaJayamaha commented

[jira] [Updated] (PHOENIX-1791) Pherf - Support data creation to multi-tenant views

2015-08-10 Thread Cody Marcel (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Cody Marcel updated PHOENIX-1791: - Fix Version/s: 4.4.1 4.5.0 4.4.0 Pherf - Support data

[jira] [Resolved] (PHOENIX-1791) Pherf - Support data creation to multi-tenant views

2015-08-10 Thread Cody Marcel (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Cody Marcel resolved PHOENIX-1791. -- Resolution: Fixed Pherf - Support data creation to multi-tenant views

[jira] [Commented] (PHOENIX-1994) TestIndexWriter#testFailureOnRunningUpdateAbortsPending() deadlocks on JDK 8

2015-08-10 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680625#comment-14680625 ] Hadoop QA commented on PHOENIX-1994: {color:red}-1 overall{color}. Here are the

[jira] [Commented] (PHOENIX-1673) Allow tenant ID to be of any integral data type

2015-08-10 Thread Eli Levine (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680632#comment-14680632 ] Eli Levine commented on PHOENIX-1673: - [~neverendingqs], there is a discussion

[jira] [Commented] (PHOENIX-1994) TestIndexWriter#testFailureOnRunningUpdateAbortsPending() deadlocks on JDK 8

2015-08-10 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680675#comment-14680675 ] Hudson commented on PHOENIX-1994: - SUCCESS: Integrated in Phoenix-master #870 (See

[jira] [Commented] (PHOENIX-1673) Allow tenant ID to be of any integral data type

2015-08-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680716#comment-14680716 ] ASF GitHub Bot commented on PHOENIX-1673: - Github user JeffreyLyonsD2L commented

[jira] [Commented] (PHOENIX-1791) Pherf - Support data creation to multi-tenant views

2015-08-10 Thread Jan Fernando (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680325#comment-14680325 ] Jan Fernando commented on PHOENIX-1791: --- [~cody.mar...@gmail.com] Is this all good

[jira] [Assigned] (PHOENIX-1994) TestIndexWriter#testFailureOnRunningUpdateAbortsPending() deadlocks on JDK 8

2015-08-10 Thread Cody Marcel (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Cody Marcel reassigned PHOENIX-1994: Assignee: Cody Marcel TestIndexWriter#testFailureOnRunningUpdateAbortsPending()

[jira] [Updated] (PHOENIX-1994) TestIndexWriter#testFailureOnRunningUpdateAbortsPending() deadlocks on JDK 8

2015-08-10 Thread Cody Marcel (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Cody Marcel updated PHOENIX-1994: - Attachment: PHOENIX-1994.patch TestIndexWriter#testFailureOnRunningUpdateAbortsPending()

[jira] [Commented] (PHOENIX-2172) PMetaDataImplTest.testEviction fails on JDK 8

2015-08-10 Thread Cody Marcel (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680584#comment-14680584 ] Cody Marcel commented on PHOENIX-2172: -- This unit test passes on JDK 7, but fails

[jira] [Created] (PHOENIX-2173) Provide a way for clients to find out the server versions from the Query Server

2015-08-10 Thread Holman Lan (JIRA)
Holman Lan created PHOENIX-2173: --- Summary: Provide a way for clients to find out the server versions from the Query Server Key: PHOENIX-2173 URL: https://issues.apache.org/jira/browse/PHOENIX-2173

[jira] [Commented] (PHOENIX-953) Support UNNEST for ARRAY

2015-08-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680809#comment-14680809 ] Julian Hyde commented on PHOENIX-953: - UNNEST produces a relation. So it can only be

[jira] [Commented] (PHOENIX-953) Support UNNEST for ARRAY

2015-08-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680981#comment-14680981 ] James Taylor commented on PHOENIX-953: -- So when UNNEST is used in a SELECT, it's

[jira] [Created] (PHOENIX-2172) PMetaDataImplTest.testEviction fails on JDK 8

2015-08-10 Thread Cody Marcel (JIRA)
Cody Marcel created PHOENIX-2172: Summary: PMetaDataImplTest.testEviction fails on JDK 8 Key: PHOENIX-2172 URL: https://issues.apache.org/jira/browse/PHOENIX-2172 Project: Phoenix Issue

[GitHub] phoenix pull request: PHOENIX-1673 Allow TenantId to be of any int...

2015-08-10 Thread elilevine
Github user elilevine commented on the pull request: https://github.com/apache/phoenix/pull/104#issuecomment-129580603 Everything looks good in terms of code. Excellent work, @JeffreyLyonsD2L. The only thing to figure out now is whether or not we should add the feature at all. I

[jira] [Created] (PHOENIX-2174) Update Calcite version to 1.3

2015-08-10 Thread James Taylor (JIRA)
James Taylor created PHOENIX-2174: - Summary: Update Calcite version to 1.3 Key: PHOENIX-2174 URL: https://issues.apache.org/jira/browse/PHOENIX-2174 Project: Phoenix Issue Type: Bug

[GitHub] phoenix pull request: PHOENIX-1673 Allow TenantId to be of any int...

2015-08-10 Thread elilevine
Github user elilevine commented on the pull request: https://github.com/apache/phoenix/pull/104#issuecomment-129690118 Thanks for the details, @JeffreyLyonsD2L. I have to say I'm still torn on whether or not this Jira makes much sense. What if I told you that your concern #2 is

[jira] [Commented] (PHOENIX-1673) Allow tenant ID to be of any integral data type

2015-08-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681166#comment-14681166 ] ASF GitHub Bot commented on PHOENIX-1673: - Github user elilevine commented on

[jira] [Commented] (PHOENIX-978) Allow views to extend base table's PK (only if last PK column is fixed length)

2015-08-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681170#comment-14681170 ] ASF GitHub Bot commented on PHOENIX-978: Github user elilevine commented on the

[GitHub] phoenix pull request: PHOENIX-978: Allow views to extend parent's ...

2015-08-10 Thread elilevine
Github user elilevine closed the pull request at: https://github.com/apache/phoenix/pull/97 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is

[jira] [Commented] (PHOENIX-978) Allow views to extend base table's PK (only if last PK column is fixed length)

2015-08-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681169#comment-14681169 ] ASF GitHub Bot commented on PHOENIX-978: Github user elilevine closed the pull

[GitHub] phoenix pull request: PHOENIX-978: Allow views to extend parent's ...

2015-08-10 Thread elilevine
Github user elilevine commented on the pull request: https://github.com/apache/phoenix/pull/97#issuecomment-129690323 Closing this PR. This has been checked in by @twdsilva. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as

[jira] [Commented] (PHOENIX-2163) Measure performance of Phoenix/Calcite querying

2015-08-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681172#comment-14681172 ] James Taylor commented on PHOENIX-2163: --- Are you unblocked now, [~shuxi0ng]? It'd

[jira] [Commented] (PHOENIX-953) Support UNNEST for ARRAY

2015-08-10 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681203#comment-14681203 ] Julian Hyde commented on PHOENIX-953: - No, you can't use UNNEST in a SELECT clause

[GitHub] phoenix pull request: PHOENIX-1673 Allow TenantId to be of any int...

2015-08-10 Thread JeffreyLyonsD2L
Github user JeffreyLyonsD2L commented on the pull request: https://github.com/apache/phoenix/pull/104#issuecomment-129597825 Hey @elilevine, thanks and I appreciate the review, I've been learning a lot :) In terms of our use case, we have a pre-existing schema that we don't

[jira] [Updated] (PHOENIX-2171) DOUBLE and FLOAT DESC are stored as ASC

2015-08-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2171: -- Attachment: PHOENIX-2171_v2.patch Updated patch with more testing. Please review,

[jira] [Commented] (PHOENIX-2137) Range query on DECIMAL DESC sometimes incorrect

2015-08-10 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681092#comment-14681092 ] Samarth Jain commented on PHOENIX-2137: --- +1. Thanks for the revision

[jira] [Updated] (PHOENIX-2137) Range query on DECIMAL DESC sometimes incorrect

2015-08-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2137?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2137: -- Attachment: PHOENIX-2137_v2.patch Final patch with more testing. Please review,

[jira] [Commented] (PHOENIX-2171) DOUBLE and FLOAT DESC are stored as ASC

2015-08-10 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681088#comment-14681088 ] Samarth Jain commented on PHOENIX-2171: --- +1, LGTM. Thanks for the revisions

[jira] [Updated] (PHOENIX-1661) Implement built-in functions for JSON

2015-08-10 Thread LeiWang (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LeiWang updated PHOENIX-1661: - Attachment: PHOENIX-1661.patch Implement built-in functions for JSON

Re: Phoenix Pig integration

2015-08-10 Thread Pariksheet Barapatre
Here are the steps - -- Phoenix version - 4.2.2 -- CDH -- 5.3 -- SQLLINE CREATE TABLE HIRES_SALTED( CLIENTID INTEGER NOT NULL, EMPID INTEGER NOT NULL, NAME VARCHAR CONSTRAINT pk PRIMARY KEY(CLIENTID,EMPID)) SALT_BUCKETS=2; UPSERT INTO HIRES_SALTED VALUES(10,100,'ABC'); UPSERT INTO HIRES_SALTED

Re: Phoenix Pig integration

2015-08-10 Thread Russell Jurney
There shouldn't be a limitation, no. I've stored to/read from Phoenix tables from Pig on CDH 5. Can you paste the error? On Monday, August 10, 2015, Pariksheet Barapatre pbarapa...@gmail.com wrote: Hi All, I am trying to run Pig script on Phoenix table. I am using same example given in

[jira] [Commented] (PHOENIX-953) Support UNNEST for ARRAY

2015-08-10 Thread ramkrishna.s.vasudevan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14679621#comment-14679621 ] ramkrishna.s.vasudevan commented on PHOENIX-953: As was discussing with

Re: Phoenix Pig integration

2015-08-10 Thread Pariksheet Barapatre
Hi Russell, below error I am getting in pig.log Failed to parse: null at org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:198) at org.apache.pig.PigServer$Graph.validateQuery(PigServer.java:1648) at org.apache.pig.PigServer$Graph.registerQuery(PigServer.java:1621)

Phoenix Pig integration

2015-08-10 Thread Pariksheet Barapatre
Hi All, I am trying to run Pig script on Phoenix table. I am using same example given in documentation. CREATE TABLE HIRES( CLIENTID INTEGER NOT NULL, EMPID INTEGER NOT NULL, NAME VARCHAR CONSTRAINT pk PRIMARY KEY(CLIENTID,EMPID)); raw = LOAD 'hbase://table/HIRES USING

[jira] [Commented] (PHOENIX-953) Support UNNEST for ARRAY

2015-08-10 Thread ramkrishna.s.vasudevan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14679726#comment-14679726 ] ramkrishna.s.vasudevan commented on PHOENIX-953: [~giacomotaylor] Can the