Search for a command to run...
Series
In this series, you can learn hive concepts like architecture, basic commands, partition, UDF ...
Steps Calculate Expected Bucket Size: Divide the table size by the block size on Hadoop to get an initial estimate. Expected Bucket Size = Table Size / Block Size on Hadoop Find the Nearest Power of 2: Take the base-2 logarithm of the ini...
In Hive, partitioning and bucketing are two techniques used for organizing and optimizing data storage and querying. Hive Partition with bucket Example Scenario: Consider a dataset containing drug sales details, and it contains 6 pid, pname, drug, ge...
smaller size Acid properties (insert update delete) Columnar storage for fast retrieval Tables used select * from orc_table; -- stored as ORC format table select * from stage_pwb_table; -- stored as text format table Create ORC table create tab...
