![]() Examples: (delimiter=E'\t'), (delimiter ':'). Preface the with an E when the value is an escape sequence. For FORMAT 'CSV', the default is a comma ( ,). Use FORMAT 'CSV' when references comma-separated value data. Use FORMAT 'TEXT' when references plain text delimited data. The default value is 0, do not skip any lines. Specify the number of header lines that PXF should skip in the first split of each before reading the data. When the value is true, PXF ignores missing path errors and returns an empty fragment. The default value is false, PXF returns an error in this situation. Specify the action to take when is missing or invalid. PXF uses the default server if not specified. The named server configuration that PXF uses to access the data. Use PROFILE hdfs:csv when references comma-separated value data. Use PROFILE hdfs:text when references plain text delimited data. must not specify a relative path nor include the dollar sign ( $) character. Otherwise, PXF considers it to be an absolute path. When the configuration includes a pxf.fs.basePath property setting, PXF considers to be relative to the base path specified. The path to the directory or file in the HDFS data store. The specific keywords and values used in the Greenplum Database CREATE EXTERNAL TABLE command are described in the table below. LOCATION ('pxf://?PROFILE=hdfs:text|csv')įORMAT '' (delimiter'') ![]() The following syntax creates a Greenplum Database readable external table that references such a text file on HDFS: CREATE EXTERNAL TABLE csv data where each row is a single record. Use the hdfs:text profile when you read plain text delimited, and hdfs:csv when reading. PrerequisitesĮnsure that you have met the PXF Hadoop Prerequisites before you attempt to read data from or write data to HDFS. PXF supports reading or writing text files compressed with the default, bzip2, and gzip codecs. ![]() This section describes how to use PXF to access HDFS text data, including how to create, query, and insert data into an external table that references files in the HDFS data store. The PXF HDFS Connector supports plain delimited and comma-separated value form text data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |