+++ This bug was initially created as a clone of Bug #1763306 +++ Description of problem: Metering tables are being stored in textfile format by default, rather than ORC which is more efficient to query and store. Version-Release number of selected component (if applicable): 4.2.0 How reproducible: Very Steps to Reproduce: 1. Exec into the presto pod: `kubectl exec presto-coordinator-0 -c presto -i -t --namespace openshift-metering -- /usr/local/bin/presto-cli --server https://presto:8080 --catalog hive --schema default --user reporting-operator --keystore-path /opt/presto/tls/keystore.pem` 2. Run the query `show create table hive.metering.datasource_openshift_metering_pod_usage_memory_bytes;` 3. See the output indicating the fileformat: Create Table ---------------------------------------------------------------------------------- CREATE TABLE hive.metering.datasource_openshift_metering_pod_usage_memory_bytes ( amount double, timestamp timestamp, timeprecision double, labels map(varchar, varchar), dt varchar ) WITH ( format = 'TEXTFILE', partitioned_by = ARRAY['dt'] ) (1 row) Actual results: Table files are stored in textformat, not ORC. Expected results: Table files are stored in ORC format. Additional info:
verified against PR, will test again once it's merged. pruan@MacBook-Pro ~/workspace/BushSlicer (master)$ kubectl exec presto-coordinator-0 -c presto -i -t --namespace openshift-metering -- /usr/local/bin/presto-cli --server https://presto:8080 --catalog hive --schema default --user reporting-operator --keystore-path /opt/presto/tls/keystore.pem presto:default> presto:default> show create table hive.metering.datasource_openshift_metering_pod_usage_memory_bytes; Create Table ----------------------------------------------------------------------------------- CREATE TABLE hive.metering.datasource_openshift_metering_pod_usage_memory_bytes ( amount double, timestamp timestamp, timeprecision double, labels map(varchar, varchar), dt varchar ) WITH ( format = 'ORC', partitioned_by = ARRAY['dt'] ) (1 row) Query 20191106_053458_00306_m4n85, FINISHED, 1 node Splits: 1 total, 1 done (100.00%) 0:00 [0 rows, 0B] [0 rows/s, 0B/s]
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2019:3869