question Re: external tables in Hive in Archives of Support Questions (Read Only)

external tables in Hive

simran_k — Mon, 06 Jun 2016 17:35:28 GMT

1. I added a CSV in HDFS using R script.

2. I update this CSV with new CSV/append data to it

3. Created table using hue in Hive over this CSV.

4. Altered it to be an external table.

Now, if when data is changed in the hdfs location, Would data be automatically updated in hive table?

Re: external tables in Hive

rajkumar_singh — Mon, 06 Jun 2016 17:44:43 GMT

if your external table is pointing to some location in hdfs and you are putting more csv data on table location which has same schema as of defined table then hive will take care of new data automatically.