Re: [ANNOUNCE] Apache Phoenix meetup in SF on Tue, Feb 24th

2015-01-22 Thread Talat Uyarer
When I try to attend the event. Meetup throw this error: "You're not allowed to join groups in other countries." Could you open country limit of joining ? 2015-01-22 20:25 GMT+02:00 James Taylor : > I'm excited to announce the first ever Apache Phoenix meetup, hosted > by salesforce.com in San Fra

Re: CsvBulkLoadTool - Exception for Local Index

2015-01-22 Thread Naga Vijayapuram
Thanks Rajeshbabu ! On Jan 22, 2015, at 8:50 PM, Rajeshbabu Chintaguntla mailto:chrajeshbab...@gmail.com>> wrote: Hi Naga Vijayapuram, Sorry I have missed that I can fix it in next week. Thanks, Rajeshbabu. On Fri, Jan 23, 2015 at 9:37 AM, Naga Vijayapuram mailto:naga_vijayapu...@gap.com>> w

Re: CsvBulkLoadTool - Exception for Local Index

2015-01-22 Thread Rajeshbabu Chintaguntla
Hi Naga Vijayapuram, Sorry I have missed that I can fix it in next week. Thanks, Rajeshbabu. On Fri, Jan 23, 2015 at 9:37 AM, Naga Vijayapuram wrote: > I have hit upon https://issues.apache.org/jira/browse/PHOENIX-1248 > > Any idea when it will be fixed? > > Thanks > Naga > > > On Jan 22,

Re: CsvBulkLoadTool - Exception for Local Index

2015-01-22 Thread Naga Vijayapuram
I have hit upon https://issues.apache.org/jira/browse/PHOENIX-1248 Any idea when it will be fixed? Thanks Naga On Jan 22, 2015, at 8:01 PM, Naga Vijayapuram mailto:naga_vijayapu...@gap.com>> wrote: Hello, Any idea why this exception shows up when running CsvBulkLoadTool? 15/01/22 22:16:50 ER

CsvBulkLoadTool - Exception for Local Index

2015-01-22 Thread Naga Vijayapuram
Hello, Any idea why this exception shows up when running CsvBulkLoadTool? 15/01/22 22:16:50 ERROR mapreduce.CsvBulkLoadTool: Import job on table=LOCAL_INDEX_ON_TABLE1 failed due to exception:java.lang.IllegalArgumentException: No regions passed What’s the “No regions passed” message about, and

回复: Phoenix Subqueries with ‘IN’

2015-01-22 Thread 【小郭】
Thank you,Maryann. And I hit another bug. for example:‍ Query1: ‍select count(1) from ( SELECT * FROM SYS_USER WHERE ID IN (80502,80604) ) as tmp_count; return1:+--+

Re: [ANNOUNCE] Apache Phoenix meetup in SF on Tue, Feb 24th

2015-01-22 Thread su...@certusnet.com.cn
Great news! Hope good slides shareing after the meetup. Wish all be good. Thanks, Sun. CertusNet From: James Taylor Date: 2015-01-23 02:25 To: user; d...@phoenix.apache.org; HBase User; HBase Dev Subject: [ANNOUNCE] Apache Phoenix meetup in SF on Tue, Feb 24th I'm excited to announce the f

Re: Convert VARCHAR to INT

2015-01-22 Thread Eli Levine
Phoenix stores VARCHAR and INTEGER values differently so your best bet is to create a new INTEGER column and write a script to move data from the VARCHAR column into the INTEGER column. If you are guaranteed that all data in your VARCHAR column are indeed numbers you can do this with a single SELEC

[ANNOUNCE] Apache Phoenix meetup in SF on Tue, Feb 24th

2015-01-22 Thread James Taylor
I'm excited to announce the first ever Apache Phoenix meetup, hosted by salesforce.com in San Francisco on Tuesday, February 24th @ 6pm. More details here: http://www.meetup.com/San-Francisco-Apache-Phoenix-Meetup/events/220009583/ Please ping me if you're interested in presenting your companies u

Re: Index Creation

2015-01-22 Thread Mujtaba Chohan
Hi Siddharth, Both scenarios of creating index before or after data load would work. If index is created before data is inserted then overall insert time would increase vs index created after data load then there would be one time cost of creating index. In case your data is immutable then using

Convert VARCHAR to INT

2015-01-22 Thread Imran Mohammed
Is it possible to convert a VARCHAR to int in phoenix ? If yes, can you please help me out with the way to do it. Regards, Imran A Mohammed.

Index Creation

2015-01-22 Thread Siddharth Ubale
Hi , I have following queries pertaining to phoenix , can u pls address them : 1. If we create a index on a phoenix table containing around million rows, would that be a problem?? 2. Is it a good practice to create indexes in the beginning , while creating tables. And put data int

Unable to connect to table after Creating Indexes (INdex creation failed midway)

2015-01-22 Thread Siddharth Ubale
Hi , Phoenix 4.2.2 Hbase 0.98 I was creating indexes for a table containing around 10 lakh rows in Phoenix. While creating one particular index the the command failed. After that I am unable to access the table on which indexing was going on. Initially it was mentioned that the Hbase status was

Re: Scan performance using JDBC result impacted by limit

2015-01-22 Thread Vijay Kukkala
Samarth, Thank you for your response. To clarify, I am not calling the PhoenixResultSet.toString(). While calling the resultSet.next() to iterate thru the items retrieved, I make a call to resultSet.getString("pc") where "pc" is the column name and of type VARCHAR. The call resultSet.getString(