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.3.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 with 4.3.0-0.nightly-2019-10-22-101148 and `metering` master branch 1. delete existing bucket or empty contents to avoid duplications from previous installs 2. git checkout master and sync to latest 3. run ./hack/openshift-install.sh 4. 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)
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-2020:0062