Skip to main content
Question

Export to parquet query doesn't return

  • Feb 24, 2020 3:07 PM UTC
  • 3 replies
  • 27 views

ronsh

Hi,
I run export to parquet query. The files are created as expected after a few minutes, but the query keeps running and doesn't return any answer (I've waited for hours).

_ EXPORT TO PARQUET ( directory = '/data_parquet/recvTimeDate_2020-02-20_half_hour') OVER
(partition by startMeasurementDate order by startMeasurement) AS SELECT
startMeasurement,column1,column2,column3, column4,column5,column6,column7,column8,
column9,column10,column11,column12,column13,column14,recvTime from public.table1 where
recvTime BETWEEN '2020-02-20 10:00:00' and '2020-02-20 10:30:00' ;_

Any idea what's the problem?

Thanks!

3 replies

DeepakMajeti
Forum|alt.badge.img
  • Participating Frequently
  • Mar 31, 2020 9:13 PM UTC

@ronsh How many rows does "public.table1" have? Do you see any errors in the vertica.log?


anatoli
  • New Participant
  • Mar 31, 2020 9:36 PM UTC

@ronsh You can also try querying v_monitor.udx_events as described here to monitor export progress (exported rows, rowgroups, etc.)


ronsh
  • Author
  • New Participant
  • Mar 31, 2020 9:40 PM UTC
Thanks guys, but we already fixed it :)
It was a linux issue.