asterixdb/asterix-app/src/test/resources/optimizerts/queries/hints/broadcast_hint_2.sqlpp

/*
 * 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.
 */
/*
* Description  : Test broadcast join hint
*                Hint on each conjunct
* Expected Res : Success
* Date         : 09/22/2017
*/

drop  dataverse test if exists;
create  dataverse test;

use test;

create type TT as closed {
  c_key : integer,
  c_1 : integer,
  c_2 : integer,
  c_3 : integer,
  c_4 : integer
};

create  dataset t1(TT) primary key c_key;

create  dataset t2(TT) primary key c_key;

select t1.c_4 as c0, t2.c_4 as c1
from t1 join t2
on t1.c_1 /*+ hash-bcast */ = t2.c_1 and t1.c_2 /*+ hash-bcast */ = t2.c_2 and t1.c_3 /*+ bcast */ = t2.c_3
;