You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Ashok kumar (Jira)" <ji...@apache.org> on 2022/09/20 06:30:00 UTC

[jira] [Created] (HIVE-26548) Hive Data load without closing the session

Ashok kumar created HIVE-26548:
----------------------------------

             Summary: Hive Data load without closing the session
                 Key: HIVE-26548
                 URL: https://issues.apache.org/jira/browse/HIVE-26548
             Project: Hive
          Issue Type: New Feature
         Environment: Test
            Reporter: Ashok kumar


Hi  i am new to hive and i want understand what is the best way to load the below  data.

 

I am receving 50 countries data in a separate db for each country,  each db has 250 tables also the dbs will be avaible in different dates with suffix,my reporting team needs consolidated db data for their analysis. So i have implemented,   a loop using shell script to load data from each table and insert it into targrt table , which this approach hive is creating a seasion and closing a session for each table ,hence it is taking days to complete the process. Can any one help the best way to implement it using shell and hive.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)