| --! qt:authorizer |
| --! qt:scheduledqueryservice |
| --! qt:sysdb |
| |
| set user.name=hive_admin_user; |
| set role admin; |
| |
| -- create external table |
| create external table t (a integer); |
| |
| -- disable autogather |
| set hive.stats.autogather=false; |
| |
| insert into t values (1),(2),(3); |
| |
| -- basic stats show that the table has "0" rows |
| desc formatted t; |
| |
| -- create a schedule to compute stats in the far future |
| create scheduled query t_analyze cron '0 0 0 1 * ? 2030' as analyze table t compute statistics for columns; |
| |
| alter scheduled query t_analyze execute; |
| |
| !sleep 30; |
| |
| select * from information_schema.scheduled_executions s where schedule_name='ex_analyze' order by scheduled_execution_id desc limit 3; |
| |
| -- and the numrows have been updated |
| desc formatted t; |
| |
| |