Member since
11-06-2020
7
Posts
0
Kudos Received
0
Solutions
11-14-2020
07:17 AM
Thanks a lot @tusharkathpal for your detailed explanation. Your suggestion has really worked.
... View more
11-08-2020
06:57 PM
@tusharkathpal Thanks for the explanation. Are you sure there is no other way to know the size of the view table. I tried with hdfs dfs -ls command but we have tables in partition so not able to locate the exact table. I can check the size by running hdfs dfs -du -s -h on the path on different directories and sub directories. A quick reply will be highly appreciated.
... View more
11-07-2020
05:10 AM
these is the error I got: Error: Error while compiling statement: FAILED: SemanticException [Error 10091]: ANALYZE is not supported for views (state=42000,code=10091) Please suggest any other command for views.
... View more
11-06-2020
07:29 AM
Hello, I am unable to know the size of the hive table. Actually it is a view specifically which we wanted to know the size of. I have tried by running commands such as hdfs dfs -du -s -h /path/to/table, but the view can't be found in the location. beeline> describe formatted/extended table name; Also does not give the output I also tried with ANALYZE but no output as well. Can some one tell me how to know the size of the view table. Since we have created view of the different table in database. And we want to know the size of the particular table.
... View more
Labels:
- Labels:
-
Apache Hive