I have created one table in the Hive database. I want to list down all the partitions of that table. Can anyone tell me how to do that?
You can list down all the partitions of a table in two ways. One is using the hive command, and another one is with the hive prompt. You can see the below example.
$hive -e show partitions table_name;
$ hive> show partitions table_name;
Changing location requires 2 steps:
1.) Change location ...READ MORE
If you want to see the content ...READ MORE
Well, what you can do is use ...READ MORE
You can try this:
CREATE TABLE temp
Firstly you need to understand the concept ...READ MORE
org.apache.hadoop.mapred is the Old API
org.apache.hadoop.mapreduce is the ...READ MORE
You can create one directory in HDFS ...READ MORE
In your case there is no difference ...READ MORE
You can use the alter table command ...READ MORE
You can use Hadoop file system command to ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.