presto can't insert data #1122
Description
After install metering, I check the logs of reporting-operator，it shows error: io.prestosql.spi.PrestoException: Failed checking path: file:/user/hive/warehouse/metering.db/datasource_metering_persistentvolumeclaim_request_bytes
Then i try a test. In Hive i create a table and insert data to the table ,it's successful. I check this table from Prosto, i can see it. But when i insert data in it，it return the same error like:
presto:metering> INSERT INTO kwang_test VALUES (1, 'San Francisco');
Query 20200306_063214_01963_k6i59 failed: Failed checking path: file:/user/hive/warehouse/metering.db/kwang_test
This is my configuration:
apiVersion: metering.openshift.io/v1
kind: MeteringConfig
metadata:
name: "operator-metering"
spec:
tls:
enabled: false
presto:
spec:
coordinator:
resources:
limits:
cpu: 6
memory: 6Gi
requests:
cpu: 4
memory: 4Gi
storage:
type: "hive"
hive:
type: "sharedPVC"
sharedPVC:
claimName: "reporting-operator-pvc"
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
name: reporting-operator-pvc
namespace: metering
spec:
accessModes: ["ReadWriteMany"]
resources:
requests:
storage: 95Gi
apiVersion: v1
kind: PersistentVolume
metadata:
name: operator-metering-pv
labels:
name: operator-metering
spec:
capacity:
storage: 5Gi
accessModes:
- ReadWriteMany
hostPath:
path: "/mnt/metering/hive-metastore"
persistentVolumeReclaimPolicy: Delete
nodeAffinity:
required:
nodeSelectorTerms:
- matchExpressions:
- key: kubernetes.io/hostname
operator: In
values:
- node1
I use a local filesystem to create pvc as the Hive storage.
Anyone help, thanks a lot !