- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-12-2023 08:25 AM
Hello everyone,
So I am having an issue when running "ANALYZE TABLE COMPUTE STATISTICS FOR ALL COLUMNS". The way I understand it this should update the min/max value for a column when you run it for all or one column. One way to verify it from what I know is to use "DESCRIBE EXTENDED table_name".
The problem is that when I run ANALYZE TABLE COMPUTE STATISTICS FOR ALL COLUMNS and then use DESCRIBE EXTENDED on the table I see that that for under the "comment" column all the values are null. Per my understanding they should not be null, but have min/max values or at least something other than null.
I am also doing this for EXTERNAL tables. Did anyone run into the same issue?
- Labels:
-
Workflows