core/sql/regress/hive/TEST002

-- Tests for SQL on Hadoop PoC
-- Added April 2013
--
-- @@@ 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 LOG002 clear;
obey TEST002(setup);
cqd HDFS_IO_BUFFERSIZE '3';
obey TEST002(tests);
cqd HDFS_IO_BUFFERSIZE '32';
obey TEST002(tests);
log;
exit;

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

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

?section tests
--------------------------------------------------------------------------

log;
log SP002.LOG clear;
showplan select count(*) from customer ;
log;
sh grep hdfsBufSize_ SP002.LOG >> LOG002;
log LOG002;
select count(*) from customer ;
select count(*) from customer_address ;
select count(*) from date_dim ;
select count(*) from household_demographics ;
select count(*) from item ;
select count(*) from promotion ;
select count(*) from store ;
select count(*) from time_dim ;

cqd hive_max_esps '2';
prepare s1 from select count(*) from hive.store_sales;
explain options 'fc' s1;
execute s1;


cqd DETAILED_STATISTICS 'ALL';
select count(C_CUSTOMER_SK) from hive.customer;
select count(*) from table(statistics(NULL,NULL));
cqd DETAILED_STATISTICS 'RESET';