core/sql/regress/hive/TEST021

-- Tests for update stats for native hive tables
-- Added Sept 2015
--
-- @@@ START COPYRIGHT @@@
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements.  See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership.  The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License.  You may obtain a copy of the License at
--
--   http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied.  See the License for the
-- specific language governing permissions and limitations
-- under the License.
--
-- @@@ END COPYRIGHT @@@

log LOG021 clear;
obey TEST021(setup);
obey TEST021(tests);
log;
exit;

?section setup
--------------------------------------------------------------------------

set schema hive.hive;
cqd mode_seahive 'ON';

?section tests
--------------------------------------------------------------------------
-- test update stats on native hive tables

update statistics for table hive.hive.customer on every column sample random 1 percent;

--showstats for table customer on "C_BIRTH_YEAR" detail;
--explain options 'f' select * from customer ;
--explain options 'f' select * from customer where "C_BIRTH_YEAR" = 1973;

update statistics for table customer clear;

-- force sample table creation
cqd ustat_internal_sort 'OFF';
cqd ustat_force_temp 'ON';
update statistics for table hive.hive.store_sales on every column 
sample random 10 percent;