What are the default record and field delimiter used for hive text files?

783

What will happen in case you have not issued the command: ‘set hive.enforce.bucketing=true;’ before bucketing a table in hive in apache hive 0.x or 1.x?

725

What is the difference between Internal Table and External Table in Hive?

683

What does the following query do? Insert overwrite table employees partition (country, state) select ..., Se.cnty, se.st from staged_employees se;

880

What does meta-store means in hive?

656

What are the different types of tables available in Hive?

653

Which java class handles the output record encoding into files which result from Hive queries?

632

What are the different Complex Data Types available in Hive?

869

How do we write our own custom serde?

657

When should we use SORT BY instead of ORDER BY?

657

Are there any problems which can only be solved by MapReduce and cannot be solved by PIG? In which kind of scenarios MR jobs will be more useful than PIG?

734

What are the different Primitive Data Types available in Hive?

650

Explain bucketing in Hive?

808

What are the default read and write classes in Hive?

611

what are the different modes of Hive?

649