Is there any configuration to do, To force create table even when SELECT statement return empty data ?
0: jdbc:drill:> create table glv_abcookie_min_newsid as . . . . . . . > select . . . . . . . > app_sessionid, . . . . . . . > new_sessionid, . . . . . . . > min(serverTime) as min_serverTime . . . . . . . > from . . . . . . . > base_newsid . . . . . . . > where . . . . . . . > STRPOS(cookie, 'Opera') > 0 . . . . . . . > group by . . . . . . . > app_sessionid, . . . . . . . > new_sessionid ; +-----------+----------------------------+ | Fragment | Number of records written | +-----------+----------------------------+ | 1_2 | 0 | | 1_1 | 0 | | 1_3 | 0 | | 1_0 | 0 | | 1_5 | 0 | | 1_4 | 0 | | 1_6 | 0 | | 1_7 | 0 | | 1_8 | 0 | | 1_10 | 0 | | 1_11 | 0 | | 1_12 | 0 | | 1_14 | 0 | | 1_9 | 0 | | 1_15 | 0 | | 1_18 | 0 | | 1_13 | 0 | | 1_19 | 0 | | 1_16 | 0 | | 1_17 | 0 | | 1_20 | 0 | | 1_21 | 0 | | 1_22 | 0 | +-----------+----------------------------+ 23 rows selected (39.99 seconds) 0: jdbc:drill:> select * from glv_abcookie_min_newsid limit 1 ; Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 37: Table 'glv_abcookie_min_newsid' not found SQL Query null [Error Id: de854901-99a3-4237-90be-0162f5d995d2 on datanode2:31010] (state=,code=0)
