Использование коннектора PXF object store для чтения и записи данных в формате ORC между Greengage DB и S3

$ mkdir $PXF_BASE/servers/s3
$ cd $PXF_BASE/servers/s3
$ cp $PXF_HOME/templates/minio-site.xml .

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <property>
        <name>fs.s3a.endpoint</name>
        <value>storage.example.com</value>
    </property>
    <property>
        <name>fs.s3a.access.key</name>
        <value>${ACCESS_KEY}</value>
    </property>
    <property>
        <name>fs.s3a.secret.key</name>
        <value>${SECRET_KEY}</value>
    </property>
    <property>
        <name>fs.s3a.fast.upload</name>
        <value>true</value>
    </property>
    <property>
        <name>fs.s3a.path.style.access</name>
        <value>true</value>
    </property>
</configuration>

$ pxf cluster sync

CREATE EXTERNAL TABLE customers_r (
        id INT,
        name TEXT,
        ordered_items TEXT[]
    )
    LOCATION('pxf://customers/customers.orc?PROFILE=s3:orc&SERVER=s3')
    FORMAT 'CUSTOM' (FORMATTER='pxfwritable_import');

SELECT * FROM customers_r;

SELECT * FROM customers_r WHERE ordered_items && '{"laptop", "monitor"}';

SELECT * FROM customers_r WHERE ordered_items[1] = 'headphones';

CREATE WRITABLE EXTERNAL TABLE customers_w (
        id INT,
        name TEXT, 
        ordered_items TEXT[]    
    )
    LOCATION ('pxf://customers/customers_w?PROFILE=s3:orc&SERVER=s3&COMPRESSION_CODEC=none')
    FORMAT 'CUSTOM' (FORMATTER='pxfwritable_export');

INSERT INTO customers_w 
VALUES (1, 'Bob Brown', ARRAY['monitor', 'webcam']),
       (2, 'John Doe', ARRAY['keyboard', 'microphone']),
       (3, 'Alice Green', ARRAY['headphones', 'pad']),
       (4, 'Jane Smith', ARRAY['laptop', 'mouse']);

$ java -jar /tmp/orc-tools-2.2.2-uber.jar meta -d /tmp/customers_w

Processing data file file:/tmp/customers_w/204-0000000021_0.orc [length: 600]
{"id":2,"name":"John Doe","ordered_items":["keyboard","microphone"]}
______________________________________________________________________________
Processing data file file:/tmp/customers_w/204-0000000021_1.orc [length: 587]
{"id":1,"name":"Bob Brown","ordered_items":["monitor","webcam"]}
______________________________________________________________________________
Processing data file file:/tmp/customers_w/204-0000000021_3.orc [length: 602]
{"id":3,"name":"Alice Green","ordered_items":["headphones","pad"]}
______________________________________________________________________________
Processing data file file:/tmp/customers_w/204-0000000021_2.orc [length: 586]
{"id":4,"name":"Jane Smith","ordered_items":["laptop","mouse"]}
______________________________________________________________________________