티스토리 뷰

공부 (@Deprecated)

[hive] delete table (insert overwrite table)

승가비 2023. 1. 5. 02:07
728x90
insert overwrite table your_table 
    select * from your_table 
    where id <> 1
;

https://stackoverflow.com/questions/17810537/how-to-delete-and-update-a-record-in-hive

 

How to delete and update a record in Hive

I have installed Hadoop, Hive, Hive JDBC. which are running fine for me. But I still have a problem. How to delete or update a single record using Hive because delete or update command of MySQL is ...

stackoverflow.com

 

728x90
저작자표시 비영리 (새창열림)

'공부 (@Deprecated)' 카테고리의 다른 글

[sh] crontab -e not working `* * * * * source ~/.zshrc && asdf.sh`  (0) 2023.01.05
[sh] txt file for loop (while)  (0) 2023.01.05
[sh] `cmd > stderr.txt 2>&1` or `cmd >> stderr.txt 2>&1`  (0) 2023.01.05
[emr] spark.json (yarn.nodemanager.resource.memory-mb, yarn.scheduler.maximum-allocation-mb)  (0) 2023.01.05
[sh] replace `echo $LINE | sed -e "s/12345678/${replace}/g"`  (0) 2023.01.05
댓글