Recent activity by Tate

Q: To see the partitions present in a Hive table the command used is

answered Apr 3, 2020 in Big Data | Hadoop

Q: The main advantage of creating table partition is

answered Apr 3, 2020 in Big Data | Hadoop

Q: The "strict" mode when querying a partitioned table is used to

answered Apr 3, 2020 in Big Data | Hadoop

Q: The partitioning of a table in Hive creates more

answered Apr 3, 2020 in Big Data | Hadoop

Q: To see the data types details of only a column notthetable we should use the command

answered Apr 3, 2020 in Big Data | Hadoop

Q: The 2 default TBLPROPERTIES added by hive when a hive table is created is

answered Apr 3, 2020 in Big Data | Hadoop

Q: The difference between the MAP and STRUCT data type in Hive is

answered Apr 3, 2020 in Big Data | Hadoop

Q: On dropping an external table

answered Apr 3, 2020 in Big Data | Hadoop

Q: On dropping a managed table

answered Apr 3, 2020 in Big Data | Hadoop

Q: The drawback of managed tables in hive is

answered Apr 3, 2020 in Big Data | Hadoop

Q: In Hive you can copy

answered Apr 3, 2020 in Big Data | Hadoop

Q: Using the ALTER DATABASE command in an database you can change the

answered Apr 3, 2020 in Big Data | Hadoop

Q: If the database contains some tables then it can be forced to drop without dropping the tables by using the keyword

answered Apr 3, 2020 in Big Data | Hadoop

Q: By default when a database is dropped in Hive

answered Apr 3, 2020 in Big Data | Hadoop

Q: The tables created in hive are stored as

answered Apr 3, 2020 in Big Data | Hadoop

Q: Each database created in hive is stored as

answered Apr 3, 2020 in Big Data | Hadoop

Q: The query "SHOW DATABASE LIKE 'h.*' ; gives the output with database name

answered Apr 3, 2020 in Big Data | Hadoop

Q: in hive when the schema does not match the file content

answered Apr 3, 2020 in Big Data | Hadoop

answered Apr 3, 2020 in Big Data | Hadoop

Q: The default delimiter in hive to separate the element in STRUCT is

answered Apr 3, 2020 in Big Data | Hadoop

...