[jira] [Commented] (PHOENIX-423) Support DISTINCT for AVG

2016-05-10 Thread ramkrishna.s.vasudevan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279602#comment-15279602 ] ramkrishna.s.vasudevan commented on PHOENIX-423: Can I assign this to [~Alexander

[jira] [Commented] (PHOENIX-424) Support DISTINCT for SUM

2016-05-10 Thread ramkrishna.s.vasudevan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279601#comment-15279601 ] ramkrishna.s.vasudevan commented on PHOENIX-424: Can I assign this to [~Alexander

Create view using select *

2016-05-10 Thread Swapna Swapna
I have an existing hbase table with 50k columns. Can we create a view in phoenix by mapping to an existing hbase table without specifying the schema of all 50k columns. Something like: Create view myview (pk varchar primary key) as select * from hbasetable For all columns to be available in my

[jira] [Updated] (PHOENIX-2877) Add the ability to control the location of the QueryServer's log, out, and pid files

2016-05-10 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser updated PHOENIX-2877: Assignee: Rob Leidle > Add the ability to control the location of the QueryServer's log, out, and

Re: Question on aggregate function

2016-05-10 Thread Swapna Swapna
That helps. Thank You James. I'm in the right direction not trying further to achieve non-standard multi arg version of an aggregate function :):) And as a next step, I will push my existing (single col) aggregate function and will keep you posted. Regards Swapna On Tue, May 10, 2016 at 10:57

[jira] [Commented] (PHOENIX-2791) Support append only schema declaration

2016-05-10 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279313#comment-15279313 ] Hudson commented on PHOENIX-2791: - SUCCESS: Integrated in Phoenix-master #1220 (See

[jira] [Commented] (PHOENIX-2888) Aggregations for similar IN list expressions doesn't work correctly

2016-05-10 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279205#comment-15279205 ] Sergey Soldatov commented on PHOENIX-2888: -- Aggregation functions are collected in

[jira] [Updated] (PHOENIX-2888) Aggregations for similar IN list expressions doesn't work correctly

2016-05-10 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-2888: - Attachment: PHOENIX-2888-1.patch improved hashCode() and equals() methods. >

[jira] [Created] (PHOENIX-2888) Aggregations for similar IN list expressions doesn't work correctly

2016-05-10 Thread Sergey Soldatov (JIRA)
Sergey Soldatov created PHOENIX-2888: Summary: Aggregations for similar IN list expressions doesn't work correctly Key: PHOENIX-2888 URL: https://issues.apache.org/jira/browse/PHOENIX-2888

Re: Phoenix Performance issue

2016-05-10 Thread Mujtaba Chohan
Tried the following in Sqlline/Phoenix and HBase shell. Both take ~20ms for point lookups with local HBase. hbase(main):015:0> get 'MYTABLE','a' COLUMN CELL 0:MYCOLtimestamp=1462515518048, value=b 0:_0 timestamp=1462515518048,

[jira] [Commented] (PHOENIX-2784) phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading DataFrames

2016-05-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279134#comment-15279134 ] James Taylor commented on PHOENIX-2784: --- Unless there are further objections, how about getting

[jira] [Updated] (PHOENIX-2784) phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading DataFrames

2016-05-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2784: -- Fix Version/s: 4.8.0 > phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading

[jira] [Commented] (PHOENIX-2877) Add the ability to control the location of the QueryServer's log, out, and pid files

2016-05-10 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279125#comment-15279125 ] Josh Elser commented on PHOENIX-2877: - Oops, I'm so sorry, I totally got distracted. At a glance,

[jira] [Commented] (PHOENIX-2877) Add the ability to control the location of the QueryServer's log, out, and pid files

2016-05-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15279043#comment-15279043 ] James Taylor commented on PHOENIX-2877: --- Are you fine with this change, [~elserj]? > Add the

[jira] [Updated] (PHOENIX-2887) Uberjar application fail with "IllegalAccessError: class com.google.protobuf.ZeroCopyLiteralByteString cannot access its superclass com.google.protobuf.LiteralByteStrin

2016-05-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2887: -- Fix Version/s: 4.8.0 > Uberjar application fail with "IllegalAccessError: class >

[jira] [Updated] (PHOENIX-2887) Uberjar application fail with "IllegalAccessError: class com.google.protobuf.ZeroCopyLiteralByteString cannot access its superclass com.google.protobuf.LiteralByteStrin

2016-05-10 Thread Nick Dimiduk (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nick Dimiduk updated PHOENIX-2887: -- Description: Uberjar applications operating over Phoenix 4.7.0 are expressing the same

[jira] [Created] (PHOENIX-2887) Uberjar application fail with "IllegalAccessError: class com.google.protobuf.ZeroCopyLiteralByteString cannot access its superclass com.google.protobuf.LiteralByteStrin

2016-05-10 Thread Nick Dimiduk (JIRA)
Nick Dimiduk created PHOENIX-2887: - Summary: Uberjar application fail with "IllegalAccessError: class com.google.protobuf.ZeroCopyLiteralByteString cannot access its superclass com.google.protobuf.LiteralByteString" Key:

Phoenix Performance issue

2016-05-10 Thread Naveen Nahata ( SC )
Hi, I am using phoenix 4.5.2-HBase-0.98 to connect HBase. To benchmark phoenix perforance executed select statement on primary key using phoenix driver and hbase client. Surprisingly figured out PhoenixDriver is approx. 10~15 times slower then hbase client. ​ Addition to this looked explain

[jira] [Created] (PHOENIX-2886) Union ALL with Char column not present in the table in Query 1 but in Query 2 throw exception

2016-05-10 Thread Alicia Ying Shu (JIRA)
Alicia Ying Shu created PHOENIX-2886: Summary: Union ALL with Char column not present in the table in Query 1 but in Query 2 throw exception Key: PHOENIX-2886 URL:

Phoenix Performance issue

2016-05-10 Thread Naveen Nahata
Hi, I am using phoenix 4.5.2-HBase-0.98 to connect HBase. To benchmark phoenix perforance executed select statement on primary key using phoenix driver and hbase client. Surprisingly figured out PhoenixDriver is approx. 10~15 times slower then hbase client. ​ Addition to this looked explain

Re: Question on aggregate function

2016-05-10 Thread James Taylor
Yes, the way to optimize it is to not represent data in column qualifiers, but as the value of a column instead (perhaps in the primary key constraint) and to do the group by query I mentioned before. Otherwise, you can do separate aggregations as you've shown as it'd perform the same as trying

Re: Question on aggregate function

2016-05-10 Thread Swapna Swapna
Hi James, thanks for your response. In the below example, us & uk are column qualifiers. * rowkeyc:usc:uk* 20161001 3 4 20161002 1 2 This is how my query looks like: select sum1(us) as US, sum1(uk) as UK from table;

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278462#comment-15278462 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62710798 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/hbase/index/write/ParallelWriterIndexCommitter.java --- @@ -116,7 +117,10 @@ public void

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278461#comment-15278461 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62710902 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/index/PhoenixTransactionalIndexer.java --- @@ -160,6 +163,9 @@ public void

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278340#comment-15278340 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62700523 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/schema/MetaDataClient.java --- @@ -1016,7 +1016,7 @@ private MutationState

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278333#comment-15278333 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62699657 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/iterate/ExplainTable.java --- @@ -198,8 +198,14 @@ private void

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278332#comment-15278332 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62699243 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/index/IndexMaintainer.java --- @@ -861,7 +871,12 @@ public Put

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62698174 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/execute/DelegateHTable.java --- @@ -297,4 +297,28 @@ public boolean checkAndDelete(byte[] row,

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278322#comment-15278322 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278317#comment-15278317 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62698009 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java --- @@ -202,7 +207,10 @@ protected

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278313#comment-15278313 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62697744 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/coprocessor/UngroupedAggregateRegionObserver.java --- @@ -165,6 +165,9 @@ public RegionScanner

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278300#comment-15278300 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on a diff in the

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on a diff in the pull request: https://github.com/apache/phoenix/pull/168#discussion_r62696240 --- Diff: phoenix-core/src/it/java/org/apache/phoenix/end2end/SortMergeJoinIT.java --- @@ -187,13 +186,13 @@ public void initTable() throws Exception {

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278279#comment-15278279 ] ASF GitHub Bot commented on PHOENIX-1734: - Github user JamesRTaylor commented on the pull

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread JamesRTaylor
Github user JamesRTaylor commented on the pull request: https://github.com/apache/phoenix/pull/168#issuecomment-218194916 How about a version that doesn't depend on HBASE-15600 so that we can continue to support older versions of HBase (and can do a 4.8 release)? What we've typically

[jira] [Commented] (PHOENIX-1734) Local index improvements

2016-05-10 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278131#comment-15278131 ] ASF GitHub Bot commented on PHOENIX-1734: - GitHub user chrajeshbabu opened a pull request:

[GitHub] phoenix pull request: PHOENIX-1734 Local index improvements(Rajesh...

2016-05-10 Thread chrajeshbabu
GitHub user chrajeshbabu opened a pull request: https://github.com/apache/phoenix/pull/168 PHOENIX-1734 Local index improvements(Rajeshbabu) This is the patch for new implementation of local index where we store local index data in the separate column families in the same table

Re: Question on aggregate function

2016-05-10 Thread James Taylor
We don't have aggregate functions with multiple arguments, so I can't provide any pointers. It's unclear what semantics you're trying to achieve with the multiple arguments. Can you give a concrete example? Based on your other example, you'd want to do a GROUP BY, like this: select sum(col) from

[jira] [Commented] (PHOENIX-2791) Support append only schema declaration

2016-05-10 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15277711#comment-15277711 ] James Taylor commented on PHOENIX-2791: --- +1. Looks good, [~tdsilva]. I agree, the view should be