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
, 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
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
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
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.
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
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