[ https://issues.apache.org/jira/browse/HAWQ-862?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15352238#comment-15352238 ]
ASF GitHub Bot commented on HAWQ-862: ------------------------------------- Github user zhangh43 closed the pull request at: https://github.com/apache/incubator-hawq/pull/747 > Make user defined function get_ao_distribution work. > ---------------------------------------------------- > > Key: HAWQ-862 > URL: https://issues.apache.org/jira/browse/HAWQ-862 > Project: Apache HAWQ > Issue Type: Bug > Components: Core > Reporter: Hubert Zhang > Assignee: Hubert Zhang > > In Hawq we had a functon that could do a fast row-count on AO tables based on > querying the catalog versus issuing 'select count(*) ' SQL. Was a lot faster > for larger tables. I found the script and tried using it with HAWQ but one > of the underlying Postgres functions that gets called (get_ao_distribution) > bombs since it doesn't seem to be able to find the table files when they are > stored in HDFS. > gpadmin=# select sum(tupcount) from get_ao_distribution('public.foo'); > ERROR: could not open relation 1663/24731/24740: No such file or directory > (seg0 localhost.localdomain:40000 pid=82964) > DETAIL: Database directory "base/24731" does not exist > CONTEXT: SQL statement "select gp_segment_id, sum(tupcount) from > gp_dist_random('pg_aoseg.pg_aoseg_24738') group by (gp_segment_id)" > gpadmin=# -- This message was sent by Atlassian JIRA (v6.3.4#6332)