[
https://issues.apache.org/jira/browse/IMPALA-8433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16821495#comment-16821495
]
Thangamani Murugasamy commented on IMPALA-8433:
-----------------------------------------------
This options is available only CDH 6.2 on-wards, I have CDH 5.16, also any
option to service wide, all tables on specific cluster should be created with
parquetry format.
set DEFAULT_FILE_FORMAT=parquet;
Unknown query option: DEFAULT_FILE_FORMAT
Available query options, with their values (defaults shown in []):
Query options (defaults shown in []):
ABORT_ON_ERROR: [0]
COMPRESSION_CODEC: []
DISABLE_CODEGEN: [0]
DISABLE_ROW_RUNTIME_FILTERING: [0]
DISABLE_STREAMING_PREAGGREGATIONS: [0]
DISABLE_UNSAFE_SPILLS: [0]
EXEC_TIME_LIMIT_S: [0]
EXPLAIN_LEVEL: [1]
IDLE_SESSION_TIMEOUT: [0]
MAX_ROW_SIZE: [524288]
MEM_LIMIT: [0]
MT_DOP: []
NUM_SCANNER_THREADS: [0]
OPTIMIZE_PARTITION_KEY_SCANS: [0]
PARQUET_ARRAY_RESOLUTION: [2]
PARQUET_FALLBACK_SCHEMA_RESOLUTION: [0]
QUERY_TIMEOUT_S: [0]
REQUEST_POOL: []
RUNTIME_FILTER_MODE: [2]
RUNTIME_FILTER_WAIT_TIME_MS: [0]
S3_SKIP_INSERT_STAGING: [1]
SCRATCH_LIMIT: [-1]
SEQ_COMPRESSION_MODE: []
SYNC_DDL: [0]
Advanced Query Options:
APPX_COUNT_DISTINCT: [0]
BUFFER_POOL_LIMIT: []
COMPUTE_STATS_MIN_SAMPLE_SIZE: [1073741824]
DEFAULT_JOIN_DISTRIBUTION_MODE: [0]
DEFAULT_SPILLABLE_BUFFER_SIZE: [2097152]
DISABLE_CODEGEN_ROWS_THRESHOLD: [50000]
ENABLE_EXPR_REWRITES: [1]
EXEC_SINGLE_NODE_ROWS_THRESHOLD: [100]
HBASE_CACHE_BLOCKS: [0]
HBASE_CACHING: [0]
MAX_ERRORS: [100]
MAX_MEM_ESTIMATE_FOR_ADMISSION: [0]
MAX_NUM_RUNTIME_FILTERS: [10]
MIN_SPILLABLE_BUFFER_SIZE: [65536]
PARQUET_ANNOTATE_STRINGS_UTF8: [0]
PARQUET_DICTIONARY_FILTERING: [1]
PARQUET_FILE_SIZE: [0]
PARQUET_READ_STATISTICS: [1]
PREFETCH_MODE: [1]
REPLICA_PREFERENCE: [0]
RUNTIME_BLOOM_FILTER_SIZE: [1048576]
RUNTIME_FILTER_MAX_SIZE: [16777216]
RUNTIME_FILTER_MIN_SIZE: [1048576]
SCHEDULE_RANDOM_REPLICA: [0]
SHUFFLE_DISTINCT_EXPRS: [1]
SUPPORT_START_OVER: [false]
Shell Options
LIVE_PROGRESS: False
LIVE_SUMMARY: False
> Impala create table default storage option parameter from text to parquet
> -------------------------------------------------------------------------
>
> Key: IMPALA-8433
> URL: https://issues.apache.org/jira/browse/IMPALA-8433
> Project: IMPALA
> Issue Type: New Feature
> Reporter: Thangamani Murugasamy
> Priority: Minor
>
> We want to change the impala default table creation options from text to
> parquet.
> We have ("hive.default.fileformat.managed"=parquet ) in hive, that helps to
> store table in default as parquet format. but I don't see any similar
> parameter in impala.
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
