hive

Hive Partitions Create Hive Partition Table Create non-partition table Load data to non-partition table Set the Hive property Load data from non-partition to partition table Show All Partitions on Hive Table Add New Partition to the Hive Table Rename or Update Hive Partition Manually Renaming Partitions on HDFS When you manually modify the partitions directly […]

Start Hive Metastore Create Database SHOW DATABASES Use Database Describe Database Drop Database Hive DDL Table Commands Show Tables Describe Table Truncate Table Alter Table Drop Table Internal Tables External Table Hive – Load Data Into Table In hive with DML statements, we can add data to the Hive table in 2 different ways. Using INSERT […]

Exclude parameter is useful to exclude the tables from sqoop export operation. exclude parameter work with import-all-tables parameter. here import-all-tables will import all tables but exclude the tables in exclude list. STEP 1. Check the no of tables in mysql database. mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | company | | student | […]