[
https://issues.apache.org/jira/browse/PHOENIX-423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279630#comment-15279630
]
James Taylor commented on PHOENIX-423:
--
Yes, please do.
> Support DISTINCT for AVG
[
https://issues.apache.org/jira/browse/PHOENIX-423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279602#comment-15279602
]
ramkrishna.s.vasudevan edited comment on PHOENIX-423 at 5/11/16 5:59 AM:
--
[
https://issues.apache.org/jira/browse/PHOENIX-424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279601#comment-15279601
]
ramkrishna.s.vasudevan edited comment on PHOENIX-424 at 5/11/16 5:58 AM:
--
[
https://issues.apache.org/jira/browse/PHOENIX-423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279602#comment-15279602
]
ramkrishna.s.vasudevan commented on PHOENIX-423:
Can I assign this to [~A
[
https://issues.apache.org/jira/browse/PHOENIX-424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279601#comment-15279601
]
ramkrishna.s.vasudevan commented on PHOENIX-424:
Can I assign this to [~A
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
[
https://issues.apache.org/jira/browse/PHOENIX-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Josh Elser resolved PHOENIX-2877.
-
Resolution: Fixed
Merged! Thanks again, [~rleidle], sorry for the delayed review.
> Add the abi
[
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
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 A
[
https://issues.apache.org/jira/browse/PHOENIX-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279313#comment-15279313
]
Hudson commented on PHOENIX-2791:
-
SUCCESS: Integrated in Phoenix-master #1220 (See
[ht
[
https://issues.apache.org/jira/browse/PHOENIX-2888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279205#comment-15279205
]
Sergey Soldatov commented on PHOENIX-2888:
--
Aggregation functions are collected
[
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.
> Aggregatio
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
Project
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,
v
[
https://issues.apache.org/jira/browse/PHOENIX-2784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279134#comment-15279134
]
James Taylor commented on PHOENIX-2784:
---
Unless there are further objections, how
[
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
[
https://issues.apache.org/jira/browse/PHOENIX-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279125#comment-15279125
]
Josh Elser commented on PHOENIX-2877:
-
Oops, I'm so sorry, I totally got distracted.
[
https://issues.apache.org/jira/browse/PHOENIX-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279043#comment-15279043
]
James Taylor commented on PHOENIX-2877:
---
Are you fine with this change, [~elserj]?
[
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
> com.google.
[
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
sympto
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-
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 sta
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: https://issues.apache.org/jira/browse/PHOENI
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 sta
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 to
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;
whic
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278462#comment-15278462
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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 write(
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278461#comment-15278461
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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
preBatchMutate(Obse
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278340#comment-15278340
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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 buildIndexAtTimeStamp
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278333#comment-15278333
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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 appendPKColumnValue(StringBuilde
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278332#comment-15278332
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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 buildUpdateMutation(KeyValueBuild
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, b
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278322#comment-15278322
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278317#comment-15278317
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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 RegionScan
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278313#comment-15278313
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278300#comment-15278300
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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 {
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278279#comment-15278279
]
ASF GitHub Bot commented on PHOENIX-1734:
-
Github user JamesRTaylor commented on
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
[
https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278131#comment-15278131
]
ASF GitHub Bot commented on PHOENIX-1734:
-
GitHub user chrajeshbabu opened a pul
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 than
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 t
49 matches
Mail list logo
