Search code examples
hivehdfsorc

How to update a hive table's data after copied orc files with hdfs into the folder of that table


After insertion of orc files into the folder of a table with hdfs copy, how to update that hive table's data to see those data when querying with hive.

Best Regards.


Solution

  • If the table is not partitioned then once the files are in HDFS in the folder that is specified in the LOCATION clause, then the data should be available for querying.
    If the table is partitioned then u first need to run an ADD PARTITION statement.