You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by James Heather <ja...@mendeley.com> on 2015/08/05 15:23:49 UTC

missing column in SELECT output

Can anyone explain why I can't always see the 'modified' column in the 
table I've just created?

0: jdbc:phoenix:172.17.0.19> create table something.blobby_tab (id bigint not null primary key, email varchar(200), modified date);
No rows affected (1.118 seconds)
0: jdbc:phoenix:172.17.0.19> upsert into something.blobby_tab (id, email, modified) values (4, 'nobby', CURRENT_DATE());
1 row affected (0.061 seconds)
0: jdbc:phoenix:172.17.0.19> select id, email, modified from something.blobby_tab where modified is not null;
+------------------------------------------+--------------------------------------------------------------------------------------------------------+
|                    ID                    |                                                                                                  EMAIL |
+------------------------------------------+--------------------------------------------------------------------------------------------------------+
| 4                                        | nobby                                                                                                  |
+------------------------------------------+--------------------------------------------------------------------------------------------------------+
1 row selected (0.025 seconds)
0: jdbc:phoenix:172.17.0.19> select * from something.blobby_tab;
+------------------------------------------+--------------------------------------------------------------------------------------------------------+
|                    ID                    |                                                                                                  EMAIL |
+------------------------------------------+--------------------------------------------------------------------------------------------------------+
| 4                                        | nobby                                                                                                  |
+------------------------------------------+--------------------------------------------------------------------------------------------------------+
1 row selected (0.022 seconds)
0: jdbc:phoenix:172.17.0.19> select id, modified from something.blobby_tab;
+------------------------------------------+-------------------------+
|                    ID                    |        MODIFIED         |
+------------------------------------------+-------------------------+
| 4                                        | 2015-08-05 13:18:18.824 |
+------------------------------------------+-------------------------+
1 row selected (0.017 seconds)

I don't see it with SELECT *, or even if I request it explicitly as part 
of the full list of columns.

I'm running Phoenix 4.3.0 over HBase 1.0.

James