Выполните следующий запрос:

COPY hits
TO '/home/test/clickbench/hits.parquet'
(FORMAT 'parquet', COMPRESSION 'zstd');

CREATE VIEW hits_parquet AS SELECT
  r['watchid']::bigint AS watchid,
  r['javaenable']::smallint AS javaenable,
  r['title']::text AS title,
  r['goodevent']::smallint AS goodevent,
  r['eventtime']::timestamp AS eventtime,
  r['eventdate']::date AS eventdate,
  r['counterid']::integer AS counterid,
  r['clientip']::integer AS clientip,
  r['regionid']::integer AS regionid,
  r['userid']::bigint AS userid,
  r['counterclass']::smallint AS counterclass,
  r['os']::smallint AS os,
  r['useragent']::smallint AS useragent,
  r['url']::text AS url,
  r['referer']::text AS referer,
  r['isrefresh']::smallint AS isrefresh,
  r['referercategoryid']::smallint AS referercategoryid,
  r['refererregionid']::integer AS refererregionid,
  r['urlcategoryid']::smallint AS urlcategoryid,
  r['urlregionid']::integer AS urlregionid,
  r['resolutionwidth']::smallint AS resolutionwidth,
  r['resolutionheight']::smallint AS resolutionheight,
  r['resolutiondepth']::smallint AS resolutiondepth,
  r['flashmajor']::smallint AS flashmajor,
  r['flashminor']::smallint AS flashminor,
  r['flashminor2']::text AS flashminor2,
  r['netmajor']::smallint AS netmajor,
  r['netminor']::smallint AS netminor,
  r['useragentmajor']::smallint AS useragentmajor,
  r['useragentminor']::text AS useragentminor,
  r['cookieenable']::smallint AS cookieenable,
  r['javascriptenable']::smallint AS javascriptenable,
  r['ismobile']::smallint AS ismobile,
  r['mobilephone']::smallint AS mobilephone,
  r['mobilephonemodel']::text AS mobilephonemodel,
  r['params']::text AS params,
  r['ipnetworkid']::integer AS ipnetworkid,
  r['traficsourceid']::smallint AS traficsourceid,
  r['searchengineid']::smallint AS searchengineid,
  r['searchphrase']::text AS searchphrase,
  r['advengineid']::smallint AS advengineid,
  r['isartifical']::smallint AS isartifical,
  r['windowclientwidth']::smallint AS windowclientwidth,
  r['windowclientheight']::smallint AS windowclientheight,
  r['clienttimezone']::smallint AS clienttimezone,
  r['clienteventtime']::timestamp AS clienteventtime,
  r['silverlightversion1']::smallint AS silverlightversion1,
  r['silverlightversion2']::smallint AS silverlightversion2,
  r['silverlightversion3']::integer AS silverlightversion3,
  r['silverlightversion4']::smallint AS silverlightversion4,
  r['pagecharset']::text AS pagecharset,
  r['codeversion']::integer AS codeversion,
  r['islink']::smallint AS islink,
  r['isdownload']::smallint AS isdownload,
  r['isnotbounce']::smallint AS isnotbounce,
  r['funiqid']::bigint AS funiqid,
  r['originalurl']::text AS originalurl,
  r['hid']::integer AS hid,
  r['isoldcounter']::smallint AS isoldcounter,
  r['isevent']::smallint AS isevent,
  r['isparameter']::smallint AS isparameter,
  r['dontcounthits']::smallint AS dontcounthits,
  r['withhash']::smallint AS withhash,
  r['hitcolor']::text AS hitcolor,
  r['localeventtime']::timestamp AS localeventtime,
  r['age']::smallint AS age,
  r['sex']::smallint AS sex,
  r['income']::smallint AS income,
  r['interests']::smallint AS interests,
  r['robotness']::smallint AS robotness,
  r['remoteip']::integer AS remoteip,
  r['windowname']::integer AS windowname,
  r['openername']::integer AS openername,
  r['historylength']::smallint AS historylength,
  r['browserlanguage']::text AS browserlanguage,
  r['browsercountry']::text AS browsercountry,
  r['socialnetwork']::text AS socialnetwork,
  r['socialaction']::text AS socialaction,
  r['httperror']::smallint AS httperror,
  r['sendtiming']::integer AS sendtiming,
  r['dnstiming']::integer AS dnstiming,
  r['connecttiming']::integer AS connecttiming,
  r['responsestarttiming']::integer AS responsestarttiming,
  r['responseendtiming']::integer AS responseendtiming,
  r['fetchtiming']::integer AS fetchtiming,
  r['socialsourcenetworkid']::smallint AS socialsourcenetworkid,
  r['socialsourcepage']::text AS socialsourcepage,
  r['paramprice']::bigint AS paramprice,
  r['paramorderid']::text AS paramorderid,
  r['paramcurrency']::text AS paramcurrency,
  r['paramcurrencyid']::smallint AS paramcurrencyid,
  r['openstatservicename']::text AS openstatservicename,
  r['openstatcampaignid']::text AS openstatcampaignid,
  r['openstatadid']::text AS openstatadid,
  r['openstatsourceid']::text AS openstatsourceid,
  r['utmsource']::text AS utmsource,
  r['utmmedium']::text AS utmmedium,
  r['utmcampaign']::text AS utmcampaign,
  r['utmcontent']::text AS utmcontent,
  r['utmterm']::text AS utmterm,
  r['fromtag']::text AS fromtag,
  r['hasgclid']::smallint AS hasgclid,
  r['refererhash']::bigint AS refererhash,
  r['urlhash']::bigint AS urlhash,
  r['clid']::integer AS clid from
read_parquet('/home/test/clickbench/hits.parquet', binary_as_string => true) r;