You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Sergey Soldatov (JIRA)" <ji...@apache.org> on 2017/01/05 00:48:58 UTC
[jira] [Commented] (PHOENIX-3561) Find null value by SELECT ALL
[ https://issues.apache.org/jira/browse/PHOENIX-3561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15799867#comment-15799867 ]
Sergey Soldatov commented on PHOENIX-3561:
------------------------------------------
[~pranludi] It's not clear whether you have unexpected data instead of nulls or you got nulls instead of the real data. I tried to reproduce the case with similar table and randomly generated data, but with no success. Can you please provide the DDL for this table and how you filled it in (whether it was bulk load or upserts)?
> Find null value by SELECT ALL
> -----------------------------
>
> Key: PHOENIX-3561
> URL: https://issues.apache.org/jira/browse/PHOENIX-3561
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.2
> Reporter: pranludi
>
> table schema
> !desc tb_server_user_stat_20170103;
> +------------+--------------+-------------------------------+-----------------+------------+------------+--------------+----------------+-----------------+-----------------+-----------+----------+
> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE | TYPE_NAME | COLUMN_SIZE | BUFFER_LENGTH | DECIMAL_DIGITS | NUM_PREC_RADIX | NULLABLE | REMARKS |
> +------------+--------------+-------------------------------+-----------------+------------+------------+--------------+----------------+-----------------+-----------------+-----------+----------+
> | | | TB_SERVER_USER_STAT_20170103 | SERVER_TIME | 12 | VARCHAR | 32 | null | null | null | 0 | |
> | | | TB_SERVER_USER_STAT_20170103 | ROOMCNT | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | CURRENTUSERCNT | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND | 12 | VARCHAR | 128 | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_0 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_1 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_2 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_3 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_4 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_5 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_6 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_7 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_8 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_9 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_10 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_11 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_12 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_13 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_14 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_15 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_16 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_17 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_18 | 4 | INTEGER | null | null | null | null | 1 | |
> | | | TB_SERVER_USER_STAT_20170103 | BLIND_19 | 4 | INTEGER | null | null | null | null | 1 | |
> +------------+--------------+-------------------------------+-----------------+------------+------------+--------------+----------------+-----------------+-----------------+-----------+----------+
> data summary : avg 7000 ~ 10000
> select * from tb_server_user_stat_20170103 limit 10;
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> | SERVER_TIME | ROOMCNT | CURRENTUSERCNT | BLIND | BLIND_0 | BLIND_1 | BLIND_2 | BLIND_3 | BLIND_4 | BLIND_5 | BLIND_6 | BLIND_7 | BLIND_8 | BLIND_9 | BLIND_10 | BLIND_11 |
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> | 2017-01-03 01:40:30 | 307 | 2070 | | 253 | 161 | 106 | 260 | 227 | 202 | 90 | 71 | 50 | 24 | 9 | 19 |
> | 2017-01-03 01:40:40 | 307 | 2070 | | 253 | 161 | 106 | 260 | 227 | 202 | 90 | 71 | 50 | 24 | 9 | 19 |
> | 2017-01-03 01:40:50 | 306 | 2071 | | 252 | 161 | 106 | 262 | 228 | 202 | 90 | 71 | 50 | 24 | 9 | 19 |
> | 2017-01-03 01:41:00 | 306 | 2063 | | 247 | 163 | 103 | 264 | 223 | 201 | 90 | 71 | 49 | 25 | 9 | 19 |
> | 2017-01-03 01:41:10 | 306 | 2066 | | 250 | 159 | 101 | 266 | 223 | 202 | 90 | 70 | 49 | 25 | 9 | 18 |
> | 2017-01-03 01:41:20 | 305 | 2063 | | 250 | 159 | 99 | 270 | 223 | 200 | 90 | 71 | 50 | 24 | 10 | 18 |
> | 2017-01-03 01:41:30 | 304 | 2058 | | 248 | 158 | 99 | 269 | 221 | 197 | 90 | 70 | 50 | 26 | 10 | 18 |
> | 2017-01-03 01:41:40 | 304 | 2058 | | 246 | 157 | 99 | 270 | 218 | 196 | 88 | 70 | 50 | 25 | 11 | 19 |
> | 2017-01-03 01:41:50 | 304 | 2066 | | 244 | 160 | 100 | 269 | 221 | 194 | 88 | 70 | 50 | 24 | 12 | 19 |
> | 2017-01-03 01:42:00 | 306 | 2067 | | 249 | 161 | 98 | 269 | 221 | 192 | 89 | 70 | 50 | 24 | 12 | 18 |
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> 10 rows selected (0.132 seconds)
> issue:
> select * from tb_server_user_stat_20170103;
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> | SERVER_TIME | ROOMCNT | CURRENTUSERCNT | BLIND | BLIND_0 | BLIND_1 | BLIND_2 | BLIND_3 | BLIND_4 | BLIND_5 | BLIND_6 | BLIND_7 | BLIND_8 | BLIND_9 | BLIND_10 | BLIND_11 |
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> ~~~
> | 2017-01-03 14:49:30 | null | null | | 120 | 99 | 65 | 143 | 104 | 122 | 50 | 42 | 31 | 15 | 12 | 7 |
> ~~~
> but!!!!
> select * from tb_server_user_stat_20170103 where server_time = '2017-01-03 14:49:30';
> select * from tb_server_user_stat_20170103 where server_time = '2017-01-03 14:49:30';
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> | SERVER_TIME | ROOMCNT | CURRENTUSERCNT | BLIND | BLIND_0 | BLIND_1 | BLIND_2 | BLIND_3 | BLIND_4 | BLIND_5 | BLIND_6 | BLIND_7 | BLIND_8 | BLIND_9 | BLIND_10 | BLIND_11 |
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> | 2017-01-03 14:49:30 | 190 | 1205 | | 120 | 99 | 65 | 143 | 104 | 122 | 50 | 42 | 31 | 15 | 12 | 7 |
> +----------------------+----------+-----------------+--------+----------+----------+----------+----------+----------+----------+----------+----------+----------+----------+-----------+-----------+
> 1 row selected (0.112 seconds)
> null value not
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)