How to get first day of quarter in hive? select add_months(trunc(‘2020-10-01′,’MM’),-(month(‘2020-10-01’)-1)%3)
Yearly Archives: 2020
16 posts
How to return closest Monday date before, when date is given? It is very simple, user next_day and date_add funtions select next_day(date_add(‘YOUR_DATE’,-7),’MONDAY’) Check — first next Monday od selected date select next_day(‘2020-10-21’, ‘MONDAY’); — returns closest Monday date before select next_day(date_add(‘2020-11-15′,-7),’MONDAY’) select next_day(date_add(‘2020-11-16′,-7),’MONDAY’) select next_day(date_add(‘2020-11-17′,-7),’MONDAY’) select next_day(date_add(‘2020-11-18′,-7),’MONDAY’) select next_day(date_add(‘2020-11-19′,-7),’MONDAY’) select […]
Install Python on web server via SSH Get latest version of Python. Here you can see versions: https://www.python.org/ftp/python/ wget https://www.python.org/ftp/python/3.9.0/Python-3.9.0.tgz Decompress files: tar xvzf Python-3.9.0.tgz Open decompressed directory: cd Python-3.9.0 Install: ./configure –prefix=$HOME/.local Make: make Make install – will install pip and setup tools: make install Go to bash profile […]
How to user googletrans # pip install googletrans # http://zetcode.com/python/googletrans/ # If we do not specify the source and the destination languages, # googletrans tries to detect the language and translates it into English. import googletrans from googletrans import Translator print(googletrans.LANGUAGES) # without language source and destination choose #translator = […]
Fibonnaci in python by token: # fibbonaci: fib_list = [0, 1] for i in range(10): fib_list.append(fib_list[-2] + fib_list[-1]) print(fib_list) Or if You want Python function to generate Fibonacci def funFibonaci(numberElements_in): fib_list = [0, 1] if numberElements_in == 1: return fib_list[-2] if numberElements_in == 2: return fib_list[-1] for i in range(numberElements_in-2): […]
select slot, collect_set(size) from (select slot, size, count(d_date_id) as cnt from xxx.table1 where dt >= 20200601 group by slot, size ) x group by slot ;
here is an answer https://answers.microsoft.com/en-us/msoffice/forum/all/excel-or-word-desktop-keeps-asking-me-to-login/cf0308f7-8d98-4139-92b5-deb8139a1bb8
If you want to stop script for a while use code listed below. time.sleep(1) – sleep for a one second import timefor i in range(100): time.sleep(1) print(i)
s_date = datetime.strptime(“2020-01-01”, “%Y-%m-%d”)e_date = datetime.strptime(“2020-01-15”, “%Y-%m-%d”)delta = e_date – s_datefor i in range(delta.days + 1): day = s_date + timedelta(days=i) l.insert(i, day) #print(day)print(l) or you can define function from datetime import datetime, timedeltas_date = datetime.strptime(“2020-01-01”, “%Y-%m-%d”)e_date = datetime.strptime(“2020-01-15”, “%Y-%m-%d”)def out_date_range(argStartDate, argEndDate): delta = argEndDate – argStartDate l = [] […]
# first on numbers in range rng = range(15)print(rng)l = [*rng]print(l)
alter table table_name change column column_name column_name column_name_type after column_name2; https://community.cloudera.com/t5/Support-Questions/How-can-we-change-the-column-order-in-Hive-table-without/td-p/89495
What is SQL Server? SQL Server is a relational database management system (RDBMS) from Microsoft. In a very simple sense, it is a database system, by means of which we manage database elements such as tables, views, programming elements. SQL Server is currently the flagship database server offered by Microsoft. […]
To change table name in HIVE use code listed below: ALTER TABLE table_name RENAME TO new_table_name;
select str_to_map(column,’,’,’:’) from table ;