I'm trying to overwrite a parquet file in hdfs for a Hive table, but I noticed a bunch of individual parquet files with unique names like this,  table_directory /part-00199-edf111ef-0f7a-43ab-9393-8fc620195d4c-c000.snappy.parquet   How do I add a parquet file to a Hive table directory that's composed of several parquet file?     ... View more

Can anyone tell me what I'm doing wrong.  I'm getting the following error from the table creation below -    FAILED: ParseException line 8:37 mismatched input 'TREX' expecting ) near ''\\', bp.step_parameter_name) \n WHERE prm.data_source = '' in function specification")     CREATE TABLE new_table AS SELECT DISTINCT prm.source AS source, bp.process_stage AS process_stage FROM table1 AS prm LEFT JOIN table2 AS bp ON (prm.parameter = CONCAT(bp.step_path, '\\', bp.step_parameter_name)) WHERE (prm.data_source = 'TDATA' OR prm.data_source = 'Docs') ... View more