Re: Ambari 2.0 and phoenix friends forever :) ?

2015-05-26 Thread Sergey Belousov
B. > > Enis > > On Tue, May 26, 2015 at 2:20 PM, Nick Dimiduk wrote: > > > On Tue, May 26, 2015 at 1:56 PM, Sergey Belousov < > > sergey.belou...@gmail.com> > > wrote: > > > > > I was more interested in confirming that phoenix will not support >

Re: Ambari 2.0 and phoenix friends forever :) ?

2015-05-26 Thread Sergey Belousov
e versions to be installed concurrently. > I don't know if this is supported by other stack definitions. > > Probably this is better answered on the Ambari lists, +user@ambari. > > -n > > On Monday, May 25, 2015, Sergey Belousov > wrote: > > > Hi All > > &

Re: Ambari 2.0 and phoenix friends forever :) ?

2015-05-26 Thread Sergey Belousov
Anyone? On Mon, May 25, 2015 at 5:49 PM, Sergey Belousov wrote: > Hi All > > So Ambari 2.0 comes with long awaited metrics system what from what I > understand seats on top of OpenTSDB and also uses Phoenix 4.2 > > Question I try to figure out > > How I still can have p

Ambari 2.0 and phoenix friends forever :) ?

2015-05-25 Thread Sergey Belousov
Hi All So Ambari 2.0 comes with long awaited metrics system what from what I understand seats on top of OpenTSDB and also uses Phoenix 4.2 Question I try to figure out How I still can have phoenix 4.4 on my cluster and Ambari 2.0 without hacking HDP Stack ? What is common thinking on how to hav

Re: [VOTE] Release of Apache Phoenix 4.4.0-HBase-0.98 RC1

2015-05-20 Thread Sergey Belousov
done https://issues.apache.org/jira/browse/PHOENIX-1993 On Tue, May 19, 2015 at 1:08 PM, Nick Dimiduk wrote: > On Tue, May 19, 2015 at 6:47 AM, Sergey Belousov < > sergey.belou...@gmail.com> > wrote: > > > I still have that exception when starting sqlline thou

Re: [VOTE] Release of Apache Phoenix 4.4.0-HBase-0.98 RC1

2015-05-19 Thread Sergey Belousov
+1 We running it for several days now - no issues discovered so far. I still have that exception when starting sqlline thou - Anyone else has it? ./sqlline.py *:2181:/hbase Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:***:2181:/hbas

Re: Going to make RC for 4.4-HBase-0.98, 4.4-HBase-1.0

2015-05-11 Thread Sergey Belousov
Sure thank you On Mon, May 11, 2015 at 9:36 PM, rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > Hi Sergey, > I have sent new RCs for voting. Please have a look at them. > > Thanks, > Rajeshbabu. > > On Mon, May 11, 2015 at 8:29 PM, Sergey Belousov &l

Re: [jira] [Comment Edited] (PHOENIX-1954) Reserve chunks of numbers for a sequence

2015-05-11 Thread Sergey Belousov
I think in ORACLE they call it CACHE you define on SEQUENCE creation ... http://docs.oracle.com/cd/B28359_01/server.111/b28310/views002.htm#ADMIN11796 It not exactly the same since it defined on SEQUENCE definition (what I think make sense) Keep in mind that there will be gaps On Mon, May 11, 20

Re: Going to make RC for 4.4-HBase-0.98, 4.4-HBase-1.0

2015-05-11 Thread Sergey Belousov
Hi Rajesh Do you have any timeline on where we would be able to have RC01 for a test-drive? Thank you On Sun, May 10, 2015 at 9:52 AM, rajeshb...@apache.org < chrajeshbab...@gmail.com> wrote: > >

Re: Issue with running sqlline (phoenix 4.4 RC0)

2015-05-06 Thread Sergey Belousov
oprocessor\MetaDataProtocol.java public abstract class MetaDataProtocol extends MetaDataService { public static final int PHOENIX_MAJOR_VERSION = 4; public static final int PHOENIX_MINOR_VERSION = 3; On Wed, May 6, 2015 at 12:36 AM, Sergey Belousov wrote: > thank you Nick > will check fi

Re: Issue with running sqlline (phoenix 4.4 RC0)

2015-05-05 Thread Sergey Belousov
en assembly packaging. Whether this sinks the RC is an > >>> open > >>> > question. The binary tarball is just for convenience actually. So I > am > >>> not > >>> > sure we need to sink the RC as long as bigtop packaging can take this > >>> > tarbal

Re: Issue with running sqlline (phoenix 4.4 RC0)

2015-05-05 Thread Sergey Belousov
;Nick Dimiduk" wrote: > Do try my suggestion on the ticket using the `touch` command to create the > missing directory entry. It should fill in the gap for you. > > On Tue, May 5, 2015 at 3:39 PM, Sergey Belousov > > wrote: > > > Thank you Nick > > I

Re: Issue with running sqlline (phoenix 4.4 RC0)

2015-05-05 Thread Sergey Belousov
ticket to make the launch scripts more robust in the > future though! > > Thanks for spinning the bits. > -n > > On Tue, May 5, 2015 at 12:39 PM, Sergey Belousov < > sergey.belou...@gmail.com> > wrote: > > > Hello All > > > > I was trying 4.4 and came

Issue with running sqlline (phoenix 4.4 RC0)

2015-05-05 Thread Sergey Belousov
Hello All I was trying 4.4 and came across following issue We had phoenix-client folder with phoenix-*-client.jar and /bin folder under. Than we used sqlline.py to run our schema creation scripts. After I updated bin folder from 4.4 and phoenix client with phoenix-4.4.0-HBase-0.98-client.jar whe

Re: Thinking of RC on Thursday

2015-04-22 Thread Sergey Belousov
n I can take RC > around next Tuesday. > By the mean time I will create branches for 1.0.x and 1.1(If it's ok) as > well and see the health of it(do some testing). > What do you say? > > I think no progress for PHOENIX-1673. Any one want to take it? > @Sergey Belousov are you i

Re: Thinking of RC on Thursday

2015-04-22 Thread Sergey Belousov
would be nice if https://issues.apache.org/jira/browse/PHOENIX-1673 makes to 4.4 On Apr 22, 2015 11:42 AM, "Cody Marcel" wrote: > I have sort of combined PHOENIX-1728 > and PHOENIX-1729 > .

Re: Phoenix schema versionning

2015-03-27 Thread Sergey Belousov
set, Phoenix will recognize the schema of > the table that was present at that timestamp as well as the data that was > created up to that timestamp. > > HTH. > - Samarth > > On Fri, Mar 27, 2015 at 3:51 PM, Sergey Belousov < > sergey.belou...@gmail.com> > wrote: > &

Phoenix schema versionning

2015-03-27 Thread Sergey Belousov
Hi all On PHOENIX website in SCHEMA section mentioned that: All schema is versioned, and prior versions are stored forever. Thus, snapshot queries over older data will pick up and use the correct schema for each row. Is it anywhere I can get more info that?

Re: cutting release candidates for 3.3.1 and 4.3.1 on Tuesday

2015-03-19 Thread Sergey Belousov
> > - Samarth > > On Thu, Mar 19, 2015 at 8:44 PM, Sergey Belousov < > sergey.belou...@gmail.com> > wrote: > > > We would really have use of > > https://issues.apache.org/jira/browse/PHOENIX-1580 > > > > if possible. > > > > Thank you > >

Re: cutting release candidates for 3.3.1 and 4.3.1 on Tuesday

2015-03-19 Thread Sergey Belousov
We would really have use of https://issues.apache.org/jira/browse/PHOENIX-1580 if possible. Thank you SB On Thu, Mar 19, 2015 at 11:26 PM, Samarth Jain wrote: > I'd like to cut RCs for our next patch releases - 3.3.1 and 4.3.1 on next > Tuesday, March 24th and initiate a vote on our dev list.

Re: Phoenix ARRAY[] datatype representation through JDBC

2015-03-19 Thread Sergey Belousov
; Could you log a JIRA ticket for this? > > - Gabriel > > > On Wed, Mar 18, 2015 at 3:23 PM Sergey Belousov > > wrote: > > > Hi > > > > When I query VIEW with ARRAY[] datatype (specifically UNSIGNED_INT > ARRAY[] >

Phoenix ARRAY[] datatype representation through JDBC

2015-03-18 Thread Sergey Belousov
Hi When I query VIEW with ARRAY[] datatype (specifically UNSIGNED_INT ARRAY[] in my case) in sqlline it shows me this long string as value of the array column.. org.apache.phoenix.schema.types.PhoenixArray$PrimitiveIntPhoenixArray@d338d So am wondering if that expected behaviour and how this ali

Re: CASTing epoch (UNSIGNED_LONG) to TIMESTAMP

2015-03-18 Thread Sergey Belousov
mp) is that the literal is a BIGINT, and not an > UNSIGNED_LONG. > > As a workaround, you can cast the UNSIGNED_LONG to a BIGINT first, and then > cast it to a TIMESTAMP, i.e. > > select a, b, ts, CAST(CAST(ts AS BIGINT) AS TIMESTAMP) from vt; > > - Gabriel > > >

Re: Building PHOENIX on Windows 7x64 box

2015-03-16 Thread Sergey Belousov
On Mon, Mar 16, 2015 at 4:09 PM, Nick Dimiduk wrote: > Can you try with Java7? > > On Mon, Mar 16, 2015 at 12:41 PM, Sergey Belousov < > sergey.belou...@gmail.com > > wrote: > > > Anyone? > > > > On Fri, Mar 13, 2015 at 5:21 PM, Sergey Belousov

Re: Building PHOENIX on Windows 7x64 box

2015-03-16 Thread Sergey Belousov
Anyone? On Fri, Mar 13, 2015 at 5:21 PM, Sergey Belousov wrote: > Hi All > > I am trying to setup environment to try to contribute some code but having > problems with passing tests. I can do build without test by > > git clone https://git-wip-us.apache.org/repos/asf/phoenix.

Building PHOENIX on Windows 7x64 box

2015-03-13 Thread Sergey Belousov
Hi All I am trying to setup environment to try to contribute some code but having problems with passing tests. I can do build without test by git clone https://git-wip-us.apache.org/repos/asf/phoenix.git git checkout 4.0 mvn clean mvn package -DskipTests but when I run it with test mvn package

CASTing epoch (UNSIGNED_LONG) to TIMESTAMP

2015-03-12 Thread Sergey Belousov
Hi All I have some weird thing going on and hope somebody can help here. HBase shell: create 't','f1' put 't',"\x00\x00\x00\x01\x00\x00\x00\x01\x00\x00\x01L\x0Fz,\x1E",'f1:c1','test' sqlline: CREATE VIEW vT ( a UNSIGNED_INT NOT NULL ,b UNSIGNED_INT NOT NULL ,ts UNSIGNED_LONG NOT NULL C

Schema Migration

2015-03-12 Thread Sergey Belousov
Hi all Do you guys had any info/ideas/discussions about anything regarding schema migration tooling for the PHOENIX ? What you guys use now? Any preferable direction like http://flywaydb.org/ or http://www.liquibase.org/ or anything else? Since PHOENIX seats on top of hbase should we possibly lo

Re: [jira] [Commented] (PHOENIX-1711) Improve performance of CSV loader

2015-03-10 Thread Sergey Belousov
It compiles fine for me (with some white spaces warnings) but I can not pass the tests stuck on Running org.apache.phoenix.util.StringUtilTest Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec - in org.apache.phoenix.util.StringUtilTest Java HotSpot(TM) 64-Bit Server VM warn

Specify ALIASE for the column names in the CREATE VIEW DDL.

2015-03-09 Thread Sergey Belousov
Hello All It looks like that currently there is no way to specify aliases for the column(s) in a CREATE VIEW DDL (including AS SELECT PART). It would be very beneficiary to provid well named column names to BI tools and still stay with HBase best practices regarding minimal length of the CQ/CD na

Re: Problem with UNSIGNED_LONG ARRAY[] datatype.

2015-03-07 Thread Sergey Belousov
On Sat, Mar 7, 2015 at 1:55 AM, Nick Dimiduk wrote: > It seems ARRAY[1,2] is not being implicitly cast to a unsigned long array. > Can you try an explicit cast? What if you declare f_array as (signed) long > array? Will have a look at code and get back to you. > > On Thursday, Marc

Problem with UNSIGNED_LONG ARRAY[] datatype.

2015-03-05 Thread Sergey Belousov
Hi all I keep banging my head against the wall and kind of out of ideas at this point so I hope someone can give me little helping hand. It safe to say that I am using almost 4.3 (build just before it released) Here is what I having problem with CREATE TABLE IF NOT EXISTS dev.t1 ( f_int UNSIG

Re: [VOTE] Release of Apache Phoenix 4.3.0 RC1

2015-02-20 Thread Sergey Belousov
as mentioned before it long awaited release for us so +100 :) Do you guys have some sort of quick manual as what steps required to properly validate release? I would like to do it right. Thank you On Feb 18, 2015 11:42 AM, "James Taylor" wrote: > Hello everyone, > > This is a call for a vote on

Re: [VOTE] Release of Apache Phoenix 4.3.0 RC0

2015-02-12 Thread Sergey Belousov
+1 we are running on snapshot build #578 now due to some critical for us fixes so it long awaited release. On Tue, Feb 10, 2015 at 10:25 PM, James Taylor wrote: > Hello everyone, > > This is a call for a vote on Apache Phoenix 4.3.0 RC0. This is the > next minor release of Phoenix 4, compatible