RE: Can't add views on HBase tables after upgrade

2015-09-16 Thread Jeffrey Lyons
Thanks a bunch Samarth and James, I will switch our scripts over to use the correct way! Jeff From: James Taylor [mailto:jamestay...@apache.org] Sent: September-15-15 7:22 PM To: user <user@phoenix.apache.org> Subject: Re: Can't add views on HBase tables after upgrade Correct, you mu

Re: Can't add views on HBase tables after upgrade

2015-09-15 Thread James Taylor
, basically creating a view with a >> select statement directly over an HBase table. When I upgraded to the new >> version they fail. >> >> >> >> I guess if someone could either confirm that “CREATE VIEW T_VIEW AS >> SELECT * FROM T;” is unsupported, or point m

Re: Can't add views on HBase tables after upgrade

2015-09-15 Thread Samarth Jain
o some docs that reiterate > that, it would help my case to refactor all the scripts to fit the > supported format. > > > > Thanks, > > Jeff > > > > *From:* Samarth Jain [mailto:sama...@apache.org] > *Sent:* September-14-15 7:32 PM > *To:* user@phoenix.apache.org &g

Re: Can't add views on HBase tables after upgrade

2015-09-14 Thread Samarth Jain
Jeffrey, Can you tell us how are creating your view over the existing HBase table? For example this works for me: HBase shell: create 'T', 'f1', 'f2', 'f3' Phoenix sql line: create view T ("f1".col1 INTEGER) Note that HBase shell is case sensitive. So we need to put the family name f1 in

Re: Can't add views on HBase tables after upgrade

2015-09-12 Thread Samarth Jain
Jeffrey, I will look into this and get back to you. - Samarth On Thu, Sep 10, 2015 at 8:44 AM, Jeffrey Lyons wrote: > Hey all, > > > > I have recently tried upgrading my Phoenix version from 4.4-HBase-0.98 to > build 835 on 4.x-HBase-0.98 to get some of the new changes.

Re: Can't add views on HBase tables after upgrade

2015-09-12 Thread James Taylor
If we've broken views over HBase tables, we'll need to -1 the RC and get a fix IMO. Thanks in advance for offering to look into it, Samarth. On Sat, Sep 12, 2015 at 11:22 AM, Samarth Jain wrote: > Jeffrey, > > I will look into this and get back to you. > > - Samarth > > On

Can't add views on HBase tables after upgrade

2015-09-10 Thread Jeffrey Lyons
Hey all, I have recently tried upgrading my Phoenix version from 4.4-HBase-0.98 to build 835 on 4.x-HBase-0.98 to get some of the new changes. After the upgrade it seems that I can't add new views directly over raw HBase tables, though it seems to work fine over Phoenix tables or views. The