RESOURCE ERROR: External Sort encountered an error while spilling to disk

2019-03-12 Thread Giovanni Conte
Hello, I am doing a LAG and a SUM query over a PCAP dataset of 300Mb. I get this error: RESOURCE ERROR: External Sort encountered an error while spilling to disk Then I changetd planner.memory.max_query_memory_per_node ---> 8589934592 and with this I am able to perform the LAG but not the SUM. I

Query Timestamps in microseconds from pcap

2019-02-20 Thread Giovanni Conte
Hi, I would like to do the timestamps difference of packet captures (pcap). The problem is that, when i do: drill:zk=local> SELECT `timestamp` FROM dfs.root.`/capture_file.pcap`; i get (showing the first 2 rows) | 2019-01-30 05:00:00.207 | | 2019-01-30 05:00:00.207 | We can see milliseconds accu

Re: Drill fails to query pcap files

2019-02-06 Thread Giovanni Conte
rote: > > > > > > Hi Giovanni, > > > > > > I don't think Drill pcap format reader has such functionality. > > > > > > Kind regards, > > > Arina > > > > > >> On Wed, Feb 6, 2019 at 6:39 PM Giovanni Conte > &g

Drill fails to query pcap files

2019-02-06 Thread Giovanni Conte
Hi, I'm trying to query a pcap file and I know that there are corrupted rows (precisely line 6407), I need a command to skip this rows to avoid the following error: Error: INTERNAL_ERROR ERROR: null Fragment 0:0 Please, refer to logs for more information. [Error Id: fe17f64d-4ac8-453f-b442-9bcf68c