Re: Phoenix Performance issue

2016-05-11 Thread Naveen Nahata
Thanks Mujtaba. Could you tell me which version of phoenix are you using ? -Naveen Nahata On 11 May 2016 at 04:12, Mujtaba Chohan wrote: > 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' > CO

Fwd: error Loading via MapReduce

2016-05-11 Thread kevin
-- Forwarded message -- From: kevin Date: 2016-05-11 16:19 GMT+08:00 Subject: Re: error Loading via MapReduce To: "user.phoenix" Thanks,I did't found fs.defaultFS property be overwritten . And I have change to use pig to load table data into Phoenix. 2016-05-11 14:23 GMT+08:00

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279814#comment-15279814 ] Ankit Singhal commented on PHOENIX-2862: [~giacomotaylor], any update on this?

Re: Create view using select *

2016-05-11 Thread Sergey Soldatov
Actually it works exactly as you want. https://phoenix.apache.org/views.html Please also read Limitations chapter. It may be useful. On Tue, May 10, 2016 at 8:46 PM, Swapna Swapna wrote: > I have an existing hbase table with 50k columns. > > Can we create a view in phoenix by mapping to an existi

Re: Create view using select *

2016-05-11 Thread Ankit Singhal
And , also look at the dynamic column support. https://phoenix.apache.org/dynamic_columns.html You don't need to specify all the columns at the time of create view and you can still query other columns by specifying them during the query. On Wed, May 11, 2016 at 2:32 PM, Sergey Soldatov wrote:

[jira] [Created] (PHOENIX-2889) No exception in Phoenix-Spark when column does not exist

2016-05-11 Thread Ian Hellstrom (JIRA)
Ian Hellstrom created PHOENIX-2889: -- Summary: No exception in Phoenix-Spark when column does not exist Key: PHOENIX-2889 URL: https://issues.apache.org/jira/browse/PHOENIX-2889 Project: Phoenix

[jira] [Updated] (PHOENIX-2889) No exception in Phoenix-Spark when column does not exist

2016-05-11 Thread Ian Hellstrom (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Hellstrom updated PHOENIX-2889: --- Description: When using {{phoenixTableAsDataFrame}} on a table with auto-capitalized qualif

[jira] [Commented] (PHOENIX-2889) No exception in Phoenix-Spark when column does not exist

2016-05-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279886#comment-15279886 ] Ankit Singhal commented on PHOENIX-2889: [~hellstorm], It is already fixed in 4.

[jira] [Resolved] (PHOENIX-2889) No exception in Phoenix-Spark when column does not exist

2016-05-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal resolved PHOENIX-2889. Resolution: Duplicate > No exception in Phoenix-Spark when column does not exist > ---

[jira] [Updated] (PHOENIX-2889) No exception thrown in Phoenix-Spark when column does not exist

2016-05-11 Thread Ian Hellstrom (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Hellstrom updated PHOENIX-2889: --- Summary: No exception thrown in Phoenix-Spark when column does not exist (was: No exception

[jira] [Commented] (PHOENIX-2889) No exception thrown in Phoenix-Spark when column does not exist

2016-05-11 Thread Ian Hellstrom (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279894#comment-15279894 ] Ian Hellstrom commented on PHOENIX-2889: Cool! I think the Phoenix version must

[jira] [Issue Comment Deleted] (PHOENIX-2889) No exception thrown in Phoenix-Spark when column does not exist

2016-05-11 Thread Ian Hellstrom (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Hellstrom updated PHOENIX-2889: --- Comment: was deleted (was: Cool! I think the Phoenix version must match the Phoenix-Spark ve

[jira] [Closed] (PHOENIX-2889) No exception thrown in Phoenix-Spark when column does not exist

2016-05-11 Thread Ian Hellstrom (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ian Hellstrom closed PHOENIX-2889. -- > No exception thrown in Phoenix-Spark when column does not exist > --

Phoenix Tracing Web App Problem

2016-05-11 Thread Pranavan Theivendiram
Hi Devs, I have started the tracing web app. It is starting like starting Trace Server, logging to /tmp/phoenix/phoenix-pranavan-traceserver.log But, from the web side. I am not able to access anything. When I try to stop the trace server, I am getting the following log. no Trace Server to st

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

2016-05-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal reassigned PHOENIX-2887: -- Assignee: Ankit Singhal > 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-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-2887: --- Attachment: PHOENIX-2887.patch > Uberjar application fail with "IllegalAccessError: class >

[jira] [Issue Comment Deleted] (PHOENIX-2208) Navigation to trace information in tracing UI should be driven off of query instead of trace ID

2016-05-11 Thread Nishani (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nishani updated PHOENIX-2208: -- Comment: was deleted (was: For the regex query search can we have sql query %like ? Yes it is possibl

[jira] [Issue Comment Deleted] (PHOENIX-2208) Navigation to trace information in tracing UI should be driven off of query instead of trace ID

2016-05-11 Thread Nishani (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nishani updated PHOENIX-2208: -- Comment: was deleted (was: Hi, We can achieve this by having a module for mapping queries to tracing

[jira] [Created] (PHOENIX-2890) Extend IndexTool to allow incremental index rebuilds

2016-05-11 Thread Ankit Singhal (JIRA)
Ankit Singhal created PHOENIX-2890: -- Summary: Extend IndexTool to allow incremental index rebuilds Key: PHOENIX-2890 URL: https://issues.apache.org/jira/browse/PHOENIX-2890 Project: Phoenix

[jira] [Commented] (PHOENIX-2890) Extend IndexTool to allow incremental index rebuilds

2016-05-11 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280249#comment-15280249 ] James Taylor commented on PHOENIX-2890: --- Partial index rebuild is different becaus

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-11 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280291#comment-15280291 ] James Taylor commented on PHOENIX-2862: --- I see now, [~ankit.singhal]. Thanks for t

[jira] [Commented] (PHOENIX-2883) Region close during automatic disabling of index for rebuilding can lead to RS abort

2016-05-11 Thread Josh Elser (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280299#comment-15280299 ] Josh Elser commented on PHOENIX-2883: - Some more updates. I spent some time with [~d

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280440#comment-15280440 ] Ankit Singhal commented on PHOENIX-2862: Thanks [~jamestaylor] for looking into

[jira] [Created] (PHOENIX-2891) Support system-wide UDFs

2016-05-11 Thread Nick Dimiduk (JIRA)
Nick Dimiduk created PHOENIX-2891: - Summary: Support system-wide UDFs Key: PHOENIX-2891 URL: https://issues.apache.org/jira/browse/PHOENIX-2891 Project: Phoenix Issue Type: Improvement Af

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

2016-05-11 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-2791: Attachment: PHOENIX-2791-addendum.patch Attaching addendum patch that enhances test. > Su

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

2016-05-11 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva resolved PHOENIX-2791. - Resolution: Fixed > Support append only schema declaration > ---

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-11 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280856#comment-15280856 ] James Taylor commented on PHOENIX-2862: --- bq. could you please review the same? Not

Re: Phoenix Tracing Web App Problem

2016-05-11 Thread Nick Dimiduk
Is there anything in /tmp/phoenix/phoenix-pranavan-traceserver.log ? On Wed, May 11, 2016 at 5:00 AM, Pranavan Theivendiram < pranavan...@cse.mrt.ac.lk> wrote: > Hi Devs, > > I have started the tracing web app. It is starting like > > starting Trace Server, logging to > /tmp/phoenix/phoenix-pran

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

2016-05-11 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15280911#comment-15280911 ] Alicia Ying Shu commented on PHOENIX-2886: -- [~maryannxue] [~jamestaylor] The c

[jira] [Created] (PHOENIX-2892) Scan for pre-warming the block cache for 2ndary index should be removed

2016-05-11 Thread Enis Soztutar (JIRA)
Enis Soztutar created PHOENIX-2892: -- Summary: Scan for pre-warming the block cache for 2ndary index should be removed Key: PHOENIX-2892 URL: https://issues.apache.org/jira/browse/PHOENIX-2892 Project

[jira] [Updated] (PHOENIX-2892) Scan for pre-warming the block cache for 2ndary index should be removed

2016-05-11 Thread Enis Soztutar (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Enis Soztutar updated PHOENIX-2892: --- Attachment: phoenix-2892_v1.patch [~jamestaylor] do you have a background on why we are doin

[jira] [Commented] (PHOENIX-2892) Scan for pre-warming the block cache for 2ndary index should be removed

2016-05-11 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15281034#comment-15281034 ] James Taylor commented on PHOENIX-2892: --- Thanks for the detective work and explana

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

2016-05-11 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15281072#comment-15281072 ] Maryann Xue commented on PHOENIX-2405: -- Yes, that's correct, [~RCheungIT]. And don'

[jira] [Commented] (PHOENIX-2892) Scan for pre-warming the block cache for 2ndary index should be removed

2016-05-11 Thread Enis Soztutar (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15281077#comment-15281077 ] Enis Soztutar commented on PHOENIX-2892: Thanks James. bq. Have you tried lower

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

2016-05-11 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15281103#comment-15281103 ] Maryann Xue commented on PHOENIX-2886: -- I do think the types should be coerced for

[jira] [Commented] (PHOENIX-2892) Scan for pre-warming the block cache for 2ndary index should be removed

2016-05-11 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15281117#comment-15281117 ] James Taylor commented on PHOENIX-2892: --- bq. I believe the cluster was running wit

[jira] [Commented] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15281250#comment-15281250 ] Ankit Singhal commented on PHOENIX-2862: Thanks [~jamestaylor], my bad if I was

[jira] [Updated] (PHOENIX-2862) Do client server compatibility checks before upgrading system tables

2016-05-11 Thread Ankit Singhal (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-2862: --- Affects Version/s: 4.8.0 > Do client server compatibility checks before upgrading system tab

[jira] [Updated] (PHOENIX-2876) Using aggregation function in ORDER BY

2016-05-11 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-2876: - Attachment: PHOENIX-2876-2.patch updated version > Using aggregation function in ORDER