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
>
