Regarding removing double quotes

Hi all, I am loading a CSV file into hive. All the columns in the CSV file has values with in the double quotes. How do i remove them and load into hive? Thanks, Elango

Getting hive tables that are updated in last one week

Hi all, I want to get the list of hive tables or dbs that are updated in last week? We use HDP 3.1 and postgres as hive metastore. Also using atlas for all hive tables which are tagged. Please let me know. Thanks, Elango

Re: Getting hive tables that are updated in last one week

The following property helped me to get what I needed. show TBLPROPERTIES schemaname.tablename ('transient_lastDdlTime') Thanks, Elango On Mon, Mar 16, 2020, 10:14 PM elango vaidyanathan wrote: > > > Hi all, > > I want to get the list of hive tables or dbs that are u

Hive variable behaviour

Hi all, I am trying to create a hive variable and store the current time stamp. Then run some complex select queries and then create another variable to store current timestamp and then find the runtime. The problem I am facing is every time I use the variable it gives me the current time instead

Re: Hive variable behaviour

Hi All, any updates on this? Thanks, Elango On Fri, Nov 26, 2021, 11:09 AM elango vaidyanathan wrote: > > Hi all, > > I am trying to create a hive variable and store the current time stamp. > Then run some complex select queries and then create another variable to > store cur