phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Heather <james.heat...@mendeley.com>
Subject missing column in SELECT output
Date Wed, 05 Aug 2015 13:23:49 GMT
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

Mime
View raw message