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