0: jdbc:phoenix:> create VIEW "STREAMING"(PK VARCHAR PRIMARY KEY,"DATA"."ORDER" DOUBLE,"OFFSET"."APP_GID" VARCHAR,"OFFSET"."TOPIC_PARTITION"
0: jdbc:phoenix:> select * from streaming;
+------+------------------------+-------------------------+------------------+---------+
| PK | ORDER | APP_GID | TOPIC_PARTITION | OFFSET |
+------+------------------------+-------------------------+------------------+---------+
| g11 | -0.006635284423828125 | | | null |
| g12 | -0.0132049560546875 | | | null |
| g13 | -0.007024383544921875 | | | null |
| g14 | -0.02108154296875 | | | null |
| g15 | -0.0122589111328125 | | | null |
| g16 | -0.007398223876953125 | ssc-kafka-hbase_group1 | order_0 | 6 |
| g17 | -0.061376953125 | ssc-kafka-hbase_group1 | order_2 | 6 |
| g18 | -0.02657470703125 | ssc-kafka-hbase_group1 | order_1 | 7 |
| g19 | -0.24765625 | ssc-kafka-hbase_group1 | order_0 | 7 |
| g20 | -0.02901611328125 | ssc-kafka-hbase_group1 | order_2 | 7 |
+------+------------------------+-------------------------+------------------+---------+
10 rows selected (0.036 seconds)
0: jdbc:phoenix:> drop view streaming;
No rows affected (0.01 seconds)
0: jdbc:phoenix:> create VIEW "STREAMING"(PK VARCHAR PRIMARY KEY,"DATA"."ORDER" UNSIGNED_DOUBLE,"OFFSET"."APP_GID" VARCHAR,"OFFSET"."TOPIC_PARTITION" VARCHAR,"OFFSET"."OFFSET" UNSIGNED_LONG);
No rows affected (0.068 seconds)
0: jdbc:phoenix:> select * from streaming;
+------+--------+-------------------------+------------------+---------+
| PK | ORDER | APP_GID | TOPIC_PARTITION | OFFSET |
+------+--------+-------------------------+------------------+---------+
| g11 | 666.3 | | | null |
| g12 | 335.3 | | | null |
| g13 | 615.3 | | | null |
| g14 | 211.3 | | | null |
| g15 | 366.3 | | | null |
| g16 | 566.3 | ssc-kafka-hbase_group1 | order_0 | 6 |
| g17 | 66.3 | ssc-kafka-hbase_group1 | order_2 | 6 |
| g18 | 166.3 | ssc-kafka-hbase_group1 | order_1 | 7 |
| g19 | 16.3 | ssc-kafka-hbase_group1 | order_0 | 7 |
| g20 | 146.3 | ssc-kafka-hbase_group1 | order_2 | 7 |
+------+--------+-------------------------+------------------+---------+