pxf

pxf copied to clipboard

Help Wanted ERR HikariPool-1 - Connection is not available, request timed out after 30000ms.

1

Good afternoon I am using PXF 5.14 There was a problem, with a large number of rows more than a million, the query execution time exceeds 30 seconds, as a...

MaxSimba

Q: Support of default hive partitioning layout with gcs

4

Hello PXF team, First of all I'd like to thank you for making PXF so great product, it's really awesome! I have a question please - is there on PXF...

akotuc

- Java: Add Apache Portable Runtime (APR) as default listener - Cloud Build: Use cloudbuild to produce `tomcat-native` libraries for CentOS7 GP5, GP6, GP7 and Ubuntu 18 GP6, GP7 -...

frankgh

Does PXF have plans to support Apache Carbondata format

1

The carbondata format appears to have some advantages over Parquet for query efficiency at the expense of data size. Are there plans to support this format?

inviscid

Does GreenPlum with PXF support avro data with schema evolution

2

We have `user` data (avro files) validated and ingested into HDFS using Schema Registry(data keep on evolving) and using GreenPlum with PXF to access HDFS data. Created one external table...

vikramnshinde

pxf support read multi files

6

Does pxf support wildcard pattern to load data from s3 storage(or s3 like)? when I use methods below, all encountered error. 1. LOCATION ('pxf://BUCKET_NAME/dirname/?PROFILE=s3:text&COMPRESSION_CODEC=gzip') FORMAT 'TEXT' (delimiter=E','); 2. LOCATION ('pxf://BUCKET_NAME/dirname/*?PROFILE=s3:text&COMPRESSION_CODEC=gzip')...

vicigel

ERROR: failed sending to remote component data movement between vertica and Greenplum

1

Hi, when we are trying to push data we are getting error. some times data will get inserted and at some times we will face this issue. we are trying...

dsjoegeo

pxf_fdw hive:orc is not defined in pxf-profiles.xml;;

1

CREATE FOREIGN TABLE hive_rc SERVER hive_hdp OPTIONS ( resource 'dbname.table_name', format 'orc' ); hive:orc is not defined in pxf-profiles.xml; how to deal with this problem?

anjingde

Can't read data from hdfs when the erasure coding policy is specified

2

### Greenplum version or build I install gpdb from 6.2.1 rpm. ``` postgres=# select version(); version ------------------------------ PostgreSQL 9.4.24 (Greenplum Database 6.2.1 build commit:d90ac1a1b983b913b3950430d4d9e47ee8827fd4) on x86_64-unknown-linux-gnu, compiled by gcc (GCC)...

weiyong-dba

Poor performance quering large HDFS data with PXF

11

Problem summary: The performance of Greenplum PXF is very poor whether it reads the data on HDFS directly or accesses the data on HDFS through hive. The format of the...

LittleWuCoding