KADB使用PXF连接KES验证

export PATH=$GPHOME/pxf/bin:$PATH

export PXF_CONF=$GPHOME/pxf

export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.262.b10-1.el7.x86_64/jre

/home/mppadmin/mpp/pxf/bin/pxf cluster register

[mppadmin@mdw1 extension]$ pxf cluster register

Installing PXF extension on master host and 0 segment hosts...

PXF extension has been installed on 1 out of 1 host

/home/mppadmin/mpp/pxf/bin/pxf cluster start

[mppadmin@mdw1 templates]$ pxf cluster start

Starting PXF on master host and 0 segment hosts...

PXF started successfully on 1 out of 1 host

[mppadmin@mdw1 templates]$ pxf cluster status

Checking status of PXF servers on master host and 0 segment hosts...

PXF is running on 1 out of 1 host

 test=# \d test

                         Table "public.test"

 Column |            Type            | Collation | Nullable | Default

--------+----------------------------+-----------+----------+---------

 a      | integer                    |           |          |

 b      | character varying(20 char) |           |          |

test=# insert into test values(generate_series(1,1000000),'ccccccccccccccc');

INSERT 0 1000000

Time: 1147.879 ms (00:01.148)

create external table test(

a int,

b varchar(20))

location(‘pxf://test?profile =jdbc')

FORMAT 'CUSTOM' (FORMATTER='pxfwritable_import');

postgres=# select count(*) from test1;

  count 

---------

 2000002

(1 row)

Time: 3729.619 ms

test=# select count(*) from test;

  count 

2000002

(1 row)

Time: 112.064 ms

create writable external table test(

a int,

b varchar(20))

location('pxf://test?profile=jdbc')

FORMAT 'CUSTOM' (FORMATTER='pxfwritable_export');

postgres=# insert into test values(generate_series(1,1000000),'ccccccccccccccc');

INSERT 0 1000000

Time: 11397.677 ms

test=# insert into test values(generate_series(1,1000000),'ccccccccccccccc');

INSERT 0 1000000

Time: 1147.879 ms (00:01.148)