[jira] [Created] (PHOENIX-1450) CsvBulkLoadTool support escape-character and quote-character

2014-11-13 Thread Junyong Li (JIRA)
Junyong Li created PHOENIX-1450: --- Summary: CsvBulkLoadTool support escape-character and quote-character Key: PHOENIX-1450 URL: https://issues.apache.org/jira/browse/PHOENIX-1450 Project: Phoenix

[jira] [Commented] (PHOENIX-1450) CsvBulkLoadTool support escape-character and quote-character

2014-11-13 Thread Gabriel Reid (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14209514#comment-14209514 ] Gabriel Reid commented on PHOENIX-1450: --- Yes, this is actually a duplicate of PHOE

[jira] [Resolved] (PHOENIX-1450) CsvBulkLoadTool support escape-character and quote-character

2014-11-13 Thread Gabriel Reid (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gabriel Reid resolved PHOENIX-1450. --- Resolution: Duplicate > CsvBulkLoadTool support escape-character and quote-character > -

[jira] [Resolved] (PHOENIX-1256) Add documentation on REGEXP_SPLIT function to reference guide

2014-11-13 Thread Gabriel Reid (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gabriel Reid resolved PHOENIX-1256. --- Resolution: Fixed > Add documentation on REGEXP_SPLIT function to reference guide >

[jira] [Created] (PHOENIX-1451) Queries with limit against tenant views is broken

2014-11-13 Thread Samarth Jain (JIRA)
Samarth Jain created PHOENIX-1451: - Summary: Queries with limit against tenant views is broken Key: PHOENIX-1451 URL: https://issues.apache.org/jira/browse/PHOENIX-1451 Project: Phoenix Issue

[jira] [Updated] (PHOENIX-1451) Queries with limit against tenant views is broken

2014-11-13 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-1451: -- Attachment: PHOENIX-1451.patch Untested patch. cc [~jamestaylor] > Queries with limit again

Re: Pheonix Questions

2014-11-13 Thread Pariksheet Barapatre
Resending in case not reached to dev list On 13 November 2014 16:12, Pariksheet Barapatre wrote: > Hello Guys, > > Hope everybody keeping good. > > I have few questions - > > Tested ON - Phoenix4.1 , HBase0.98.1 , 7 RS heap Size - 8 GB > > 1) PIG gives error whenever I am trying to LOAD data fro

[jira] [Commented] (PHOENIX-1451) Queries with limit against tenant views is broken

2014-11-13 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14209649#comment-14209649 ] Samarth Jain commented on PHOENIX-1451: --- Tests ran successfully. > Queries with l

How to use Hints in Phoenix queries

2014-11-13 Thread Pariksheet Barapatre
Hi All, Want to use NO_CACHE Hint , how to use it . Any example or documentation ? http://phoenix.apache.org/language/index.html#cache_hint does not help really. UPSERT INTO TABLE1 SELECT * from TABLE2. How to use cache hint here.. Cheers, Pari

Re: How to use Hints in Phoenix queries

2014-11-13 Thread Eli Levine
You'd use with with a SELECT statement like this: SELECT /*+ NO_CACHE */ COUNT(*) FROM TABLE1; Eli On Thu, Nov 13, 2014 at 4:50 AM, Pariksheet Barapatre wrote: > Hi All, > > Want to use NO_CACHE Hint , how to use it . > > Any example or documentation ? > > http://phoenix.apache.org/language/in

[jira] [Resolved] (PHOENIX-1451) Queries with limit against tenant views is broken

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-1451. --- Resolution: Fixed Fix Version/s: 3.2.1 3.3 +1. Thanks, [~samarthja

Pheonix Questions

2014-11-13 Thread Pariksheet Barapatre
Hello Guys, Hope everybody keeping good. I have few questions - Tested ON - Phoenix4.1 , HBase0.98.1 , 7 RS heap Size - 8 GB 1) PIG gives error whenever I am trying to LOAD data from Salted Phoenix table A = LOAD 'hbase://table/RAW_LOG' USING org.apache.phoenix.pig.PhoenixHBaseLoader('pari');

[jira] [Commented] (PHOENIX-1428) Keep scanner open on server and pace by client instead of spooling

2014-11-13 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14209951#comment-14209951 ] Hudson commented on PHOENIX-1428: - SUCCESS: Integrated in Phoenix-3.0-hadoop1 #313 (See

[jira] [Commented] (PHOENIX-1428) Keep scanner open on server and pace by client instead of spooling

2014-11-13 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14209955#comment-14209955 ] Hudson commented on PHOENIX-1428: - SUCCESS: Integrated in Phoenix-master #485 (See [htt

[VOTE] Release of Apache Phoenix 4.2.1 RC1

2014-11-13 Thread James Taylor
Hello everyone, This is a call for a vote on Apache Phoenix 4.2.1 RC1. This is a bug fix/patch release of Phoenix 4.2, compatible with the 0.98 branch of Apache HBase with feature parity against the Phoenix 3.2 release. The release includes both a source-only release and a convenience binary relea

[jira] [Commented] (PHOENIX-1440) Add support for CSV quoting in bulk loader

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210072#comment-14210072 ] James Taylor commented on PHOENIX-1440: --- [~gabriel.reid] - if you're good with the

RE: Pheonix Questions

2014-11-13 Thread Vasudevan, Ramkrishna S
Hi Pariksheet 1) Seems to be an issue. Pls file a JIRA along with a unit test to indicate the problem. Similarly for (3). 2) update_statistics is available in 4.2 onwards. Regards Ram -Original Message- From: Pariksheet Barapatre [mailto:pbarapa...@gmail.com] Sent: Thursday, November

[jira] [Updated] (PHOENIX-1439) LIKE doesn't appear to use skip scanning

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1439: -- Assignee: Kyle Buzsaki > LIKE doesn't appear to use skip scanning > --

[jira] [Commented] (PHOENIX-1439) LIKE doesn't appear to use skip scanning

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210091#comment-14210091 ] James Taylor commented on PHOENIX-1439: --- [~kbuzsaki] - let me know if you have the

[jira] [Commented] (PHOENIX-1256) Add documentation on REGEXP_SPLIT function to reference guide

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210099#comment-14210099 ] James Taylor commented on PHOENIX-1256: --- I may have missed your patch (and I like

[jira] [Commented] (PHOENIX-1428) Keep scanner open on server and pace by client instead of spooling

2014-11-13 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210104#comment-14210104 ] Jeffrey Zhong commented on PHOENIX-1428: [~giacomotaylor] a wrong JIRA is used t

[jira] [Commented] (PHOENIX-1428) Keep scanner open on server and pace by client instead of spooling

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210107#comment-14210107 ] James Taylor commented on PHOENIX-1428: --- Argh. Sorry about that. Anyway to correct

[jira] [Commented] (PHOENIX-1428) Keep scanner open on server and pace by client instead of spooling

2014-11-13 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210113#comment-14210113 ] Jeffrey Zhong commented on PHOENIX-1428: Probably just leave as it is. I don't

[jira] [Commented] (PHOENIX-1256) Add documentation on REGEXP_SPLIT function to reference guide

2014-11-13 Thread Gabriel Reid (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14210156#comment-14210156 ] Gabriel Reid commented on PHOENIX-1256: --- Yeah, I went to apply the patch today and

[jira] [Created] (PHOENIX-1452) Add logging to allow easier monitoring of client-side Thread Pool and Queue usage

2014-11-13 Thread Jan Fernando (JIRA)
Jan Fernando created PHOENIX-1452: - Summary: Add logging to allow easier monitoring of client-side Thread Pool and Queue usage Key: PHOENIX-1452 URL: https://issues.apache.org/jira/browse/PHOENIX-1452

[jira] [Resolved] (PHOENIX-1440) Add support for CSV quoting in bulk loader

2014-11-13 Thread Gabriel Reid (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gabriel Reid resolved PHOENIX-1440. --- Resolution: Fixed Assignee: Gabriel Reid Pushed to 3.0, 4.0, and master branches > Ad

[VOTE] Release of Apache Phoenix 3.2.1 RC1

2014-11-13 Thread James Taylor
Hello everyone, This is a call for a vote on Apache Phoenix 3.2.1 RC1. This is a bug fix/patch release of Phoenix 3.2, compatible with the 0.94 branch of Apache HBase with feature parity against the Phoenix 4.2 release. The release includes both a source-only release and a convenience binary relea

[jira] [Updated] (PHOENIX-1380) Potential null dereference in PerformanceLog#getFileOutputStream()

2014-11-13 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alicia Ying Shu updated PHOENIX-1380: - Attachment: PHOENIX-1380_delete.patch > Potential null dereference in PerformanceLog#get

[jira] [Commented] (PHOENIX-1380) Potential null dereference in PerformanceLog#getFileOutputStream()

2014-11-13 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211210#comment-14211210 ] Alicia Ying Shu commented on PHOENIX-1380: -- Per suggestion by James, deleted Pe

[jira] [Commented] (PHOENIX-1440) Add support for CSV quoting in bulk loader

2014-11-13 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211263#comment-14211263 ] Hudson commented on PHOENIX-1440: - SUCCESS: Integrated in Phoenix-3.0-hadoop1 #314 (See

Development Environment Question

2014-11-13 Thread Quan, Ronnie
Hello Everyone, I'm new to the group, and I'm trying to go through the phoenix hello world example. Looks like it needs download phoenix code and needs HBASE installed as well. If you don't mind, can you please share where and how you setup your environment? I have access to a Hadoop environme

[jira] [Commented] (PHOENIX-1440) Add support for CSV quoting in bulk loader

2014-11-13 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211366#comment-14211366 ] Hudson commented on PHOENIX-1440: - FAILURE: Integrated in Phoenix-master #486 (See [htt

[jira] [Updated] (PHOENIX-1179) Support many-to-many joins

2014-11-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-1179: - Attachment: 1179.patch 1. Add USE_SORT_MERGE_JOIN hint 2. Otherwise queries that cannot be done

[jira] [Created] (PHOENIX-1453) Collect row counts per region in stats table

2014-11-13 Thread James Taylor (JIRA)
James Taylor created PHOENIX-1453: - Summary: Collect row counts per region in stats table Key: PHOENIX-1453 URL: https://issues.apache.org/jira/browse/PHOENIX-1453 Project: Phoenix Issue Type

[jira] [Updated] (PHOENIX-1453) Collect row counts per region in stats table

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1453: -- Description: We currently collect guideposts per equal chunk, but we should also capture row c

[jira] [Commented] (PHOENIX-1179) Support many-to-many joins

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211536#comment-14211536 ] James Taylor commented on PHOENIX-1179: --- Thanks for the contribution, [~maryannxue

[jira] [Updated] (PHOENIX-1395) ResultSpooler spill files are left behind in /tmp folder

2014-11-13 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alicia Ying Shu updated PHOENIX-1395: - Attachment: PHOENIX-1395.v1.patch > ResultSpooler spill files are left behind in /tmp fo

[jira] [Commented] (PHOENIX-1395) ResultSpooler spill files are left behind in /tmp folder

2014-11-13 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211684#comment-14211684 ] Alicia Ying Shu commented on PHOENIX-1395: -- Add test cases that when connection

[jira] [Commented] (PHOENIX-1395) ResultSpooler spill files are left behind in /tmp folder

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211687#comment-14211687 ] James Taylor commented on PHOENIX-1395: --- This issue is fixed already with PHOENIX-

[jira] [Commented] (PHOENIX-1395) ResultSpooler spill files are left behind in /tmp folder

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211695#comment-14211695 ] James Taylor commented on PHOENIX-1395: --- [~lhofhansl] - I filed PHOENIX-1428 for t

[jira] [Commented] (PHOENIX-1395) ResultSpooler spill files are left behind in /tmp folder

2014-11-13 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211709#comment-14211709 ] Jeffrey Zhong commented on PHOENIX-1395: [~giacomotaylor] I think the patch is m

[jira] [Commented] (PHOENIX-1179) Support many-to-many joins

2014-11-13 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211790#comment-14211790 ] Maryann Xue commented on PHOENIX-1179: -- Basically, hash-join is found limited for 3

[jira] [Commented] (PHOENIX-1427) Reduce work in StatsCollector

2014-11-13 Thread Lars Hofhansl (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211886#comment-14211886 ] Lars Hofhansl commented on PHOENIX-1427: Fair enough. I will do that. > Reduce

Re: Pheonix Questions

2014-11-13 Thread Ravi Kiran
Hi Pariksheet, If possible, can you please share the error log. That helps a ton! Regards Ravi On Thu, Nov 13, 2014 at 9:58 AM, Vasudevan, Ramkrishna S < ramkrishna.s.vasude...@intel.com> wrote: > Hi Pariksheet > > 1) Seems to be an issue. Pls file a JIRA along with a unit test to > indicat

[jira] [Commented] (PHOENIX-1179) Support many-to-many joins

2014-11-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1179?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211924#comment-14211924 ] James Taylor commented on PHOENIX-1179: --- +1. Adding the above as code comments at

[jira] [Created] (PHOENIX-1454) Map Reduce over Phoenix tables

2014-11-13 Thread maghamravikiran (JIRA)
maghamravikiran created PHOENIX-1454: Summary: Map Reduce over Phoenix tables Key: PHOENIX-1454 URL: https://issues.apache.org/jira/browse/PHOENIX-1454 Project: Phoenix Issue Type: New Fe