Any possibility to have es.resource with alias name


(Saran) #1

Hi All,
Is there any way I can user Alias name in es.resource while creating EXTERNAL table in HIVE using TBLPROPERTIES.
I've 2 different indexes in Elasticsearch and alias will be switched between stage and active index.
So based on alias pointed I want data to be loaded to that specific Index.


(James Baiera) #2

I don't see why you wouldn't be able to use aliases when creating a table. That said, is there anything that keeps you from just creating two table definitions and loading to the specific indices explicitly by table name instead? Do note that Hive reads and writes the data to ES as requested, so the extra table should have minimal overhead.


(Lee) #3

Actually I created hive table with both alias index and actual index. We can get data from both hive tables.

But _type must be set. (es vesion is 2.4.5)


(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.