Hi James, Thanks for the info. I am using cloudera distribution CLABS_PHOENIX-4.3.0-1.clabs_phoenix1.0.0.p0.78 that can be the issue. I will try to play with other versions.
Thx Yanlin > On Jun 16, 2015, at 9:34 AM, James Taylor <[email protected]> wrote: > > Hi Yanlin, > What version of Phoenix are you using? I tried the following in > sqlline, and it worked fine: > > 0: jdbc:phoenix:localhost> create table t1 (k varchar primary key, > col1 varchar); > No rows affected (10.29 seconds) > 0: jdbc:phoenix:localhost> select fact.col1 from (select col1 from t1) as > fact; > +------------------------------------------+ > | COL1 | > +------------------------------------------+ > +------------------------------------------+ > No rows selected (0.051 seconds) > 0: jdbc:phoenix:localhost> upsert into t1 values('a','b'); > 1 row affected (0.04 seconds) > 0: jdbc:phoenix:localhost> select fact.col1 from (select col1 from t1) as > fact; > +------------------------------------------+ > | COL1 | > +------------------------------------------+ > | b | > +------------------------------------------+ > 1 row selected (0.031 seconds) > > > On Mon, Jun 15, 2015 at 6:07 PM, yanlin wang <[email protected]> wrote: >> Hi, >> >> I am trying to setup phoenix working with some BI solution. The issue i have >> is that given a tool generated query like this -> select fact.col1 from >> (select col1 from t1) as fact, phoenix will confuse the table alias with >> column family. Any suggestion? >> >> Thx >> Yanlin >>
