Not that I know of. See https://issues.apache.org/jira/browse/DRILL-2223 - There may be issues with creating an empty Parquet file with no data. We haven't investigated that in too much detail though.
On Mon, Aug 22, 2016 at 5:48 AM, Shankar Mane <[email protected]> wrote: > 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) >
