Uncategorized Hive – array in WHERE Close by token|Published January 22, 2020 select * from mytable where array_contains(likes_and_preferences,'item') = TRUE
Published January 22, 2020 String to map key-value in HIVE select str_to_map(column,’,’,’:’) from table ;
Published November 13, 2019 How to run python file py from cmd command line https://www.wikihow.com/Use-Windows-Command-Prompt-to-Run-a-Python-File
Published April 21, 2021 [AWS Athena] Set new data location on S3 How to set other data location on s3? Just use ALTER TABLE. The example code is losted here: alter table d_ppo_category_pc_mapping set […]
Published April 26, 2021 How to edit Tableau Server extract? Local copy existing extractUse local copy source Close old extract (optional)Edit data source based on local copy