Re: Phoenix ODBC Connection

2015-07-22 Thread Sergey Belousov
I do not think it can be used from .NET yet The client implementation is currently a JDBC driver with minimal dependencies. The transport mechanism is currently JSON encoded requests over HTTP transport. There’s also a sqlline script that uses the thin client. If you feel adventurous you can try

Re: Will phoenix support the checkandput methods in the further

2015-06-26 Thread Sergey Belousov
Hi James I was under impression that UPSERT SELECT with WHERE would do the trick ? If I got it wrong what would be correct way of thinking about UPSERT SELECT with WHERE ? regards, S On Fri, Jun 26, 2015 at 11:53 AM, James Taylor jamestay...@apache.org wrote: Once transaction support goes

Re: Phoenix Connection Timeout

2015-05-22 Thread Sergey Belousov
It definitely hangs forever from what I experienced. It also does not allow to exit from it and only killing terminal session helps. On Fri, May 22, 2015 at 6:13 PM, Nick Dimiduk ndimi...@gmail.com wrote: Hi Alex, It's probably not hanging forever, but going through the -- very long by

Re: WHERE filter on VARCHAR

2015-05-21 Thread Sergey Belousov
Because NULL is not equal *!= 'deleted'. * Most databases I worked with treat null in such way (behaviour can be configured) use http://phoenix.apache.org/language/functions.html#coalesce In the ANSI SQL standard, the value of NULL is defined as unknown. It is not equal to anything, not even

Re: Phoenix Array Flatten Function

2015-04-24 Thread Sergey Belousov
https://issues.apache.org/jira/browse/PHOENIX-953 On Fri, Apr 24, 2015 at 10:16 PM, James Taylor jamestay...@apache.org wrote: Please add a sub task under PHOENIX-1665. It's related to PHOENIX-953 (Support for UNNEST for ARRAY), but more flexible. Thanks, James On Fri, Apr 24, 2015 at

Re: UPSERT SELECT works partially

2015-03-30 Thread Sergey Belousov
make sure that in upper right conner check mark next to Limit Rows is unchecked On Mon, Mar 30, 2015 at 6:28 AM, Dark Hawk d4rxh...@gmail.com wrote: Hello, I'm using Phoenix 4.3.0 on Cloudera CDH 5.3. I'm trying to use the UPSERT SELECT statement. It seems to work partially. Only a

Re: - Multitenancy - HBase Namespace ...

2015-03-12 Thread Sergey Belousov
My understanding is same as Nick HBase's namespace would be something that could possibly provide full separation of the data but until https://issues.apache.org/jira/browse/PHOENIX-1311 is done its not available in phoenix from what I know. Regards, S On Thu, Mar 12, 2015 at 7:21 PM, Nick

Re: Creating multiple views off existent HBase table.

2015-03-08 Thread Sergey Belousov
aggregation in views. The other stuff should work, though. File one JIRA per issue you find. Thanks, James On Sun, Mar 8, 2015 at 6:58 PM, Sergey Belousov sergey.belou...@gmail.com wrote: Hi James Would you be able to shred some light on issues with WHERE part for CREATE VIEW AS I am having

Re: Creating multiple views off existent HBase table.

2015-03-08 Thread Sergey Belousov
Hi James Would you be able to shred some light on issues with WHERE part for CREATE VIEW AS I am having as described in prier message? I am kind of stuck here :(. Thank you. On Fri, Mar 6, 2015 at 7:09 PM, Sergey Belousov sergey.belou...@gmail.com wrote: And in addition for CREATE VIEW

Re: Creating multiple views off existent HBase table.

2015-03-06 Thread Sergey Belousov
AS SELECT part is not same select you can do when you query VIEW? Thank you On Thu, Mar 5, 2015 at 10:36 PM, Sergey Belousov sergey.belou...@gmail.com wrote: Thank you James this one works for me too but my case little bit more complex my key is 4byte4byte4byte8bytearray[0..N of 8bytes

Re: Having difficulty to creating VIEW in Phoenix

2015-03-05 Thread Sergey Belousov
, Sergey Belousov sergey.belou...@gmail.com wrote: Hi James, Thank you for the prompt reply. My thinking of VIEW on top VIEW at this point was mainly about having one view to have wide table mapping from HBase. Than I wanted to turn it around and make tall VIEW on top of wide VIEW

Creating multiple views off existent HBase table.

2015-03-05 Thread Sergey Belousov
Hi All It seems like impossible now to create more than one view (with different names and columns of course) on top of existent HBase table. It also seems impossible to provide view name other than original HBase table name you base you view of. Are thouse statements correct or I just missing

Having difficulty to creating VIEW in Phoenix

2015-03-02 Thread Sergey Belousov
Hi All Hope you guys can help me little bit with this one. I have a table in HBase with following structure (simplified) key: epoch in seconds rounded to the day. key k1-4bytek2-4bytetsk3-4byte cf: d cq: 0..23 (hourly counters) I have no problem to create horizontal VIEW so I can do query

Having difficulty to creating VIEW in phoenix

2015-02-27 Thread Sergey Belousov
Hi All Hope you guys can help me little bit with this one. I have a table in HBase with following structure (simplified) key: epoch in seconds rounded to the day. key k1-4bytek2-4bytetsk3-4byte cf: d cq: 0..23 (hourly counters) I have no problem to create horizontal VIEW so I can do query