ColumnarResultsTest.cpp

/*
 * Copyright 2019 OmniSci, Inc.
 *
 * Licensed 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.
 */

#include "Logger/Logger.h"
#include "QueryEngine/ColumnarResults.h"
#include "QueryEngine/Descriptors/RowSetMemoryOwner.h"
#include "QueryEngine/Execute.h"
#include "QueryEngine/ResultSet.h"
#include "QueryEngine/TargetValue.h"
#include "Shared/TargetInfo.h"
#include "Tests/ResultSetTestUtils.h"
#include "Tests/TestHelpers.h"

#include <gtest/gtest.h>

extern bool g_is_test_env;

class ColumnarResultsTester : public ColumnarResults {
 public:
  ColumnarResultsTester(const std::shared_ptr<RowSetMemoryOwner> row_set_mem_owner,
                        const ResultSet& rows,
                        const size_t num_columns,
                        const std::vector<SQLTypeInfo>& target_types,
                        const bool is_parallel_execution_enforced = false)
      : ColumnarResults(row_set_mem_owner,
                        rows,
                        num_columns,
                        target_types,
                        is_parallel_execution_enforced) {}

  template <typename ENTRY_TYPE>
  ENTRY_TYPE getEntryAt(const size_t row_idx, const size_t column_idx) const {
    CHECK_LT(column_idx, column_buffers_.size());
    CHECK_LT(row_idx, num_rows_);
    return reinterpret_cast<ENTRY_TYPE*>(column_buffers_[column_idx])[row_idx];
  }
};

template <>
float ColumnarResultsTester::getEntryAt<float>(const size_t row_idx,
                                               const size_t column_idx) const {
  CHECK_LT(column_idx, column_buffers_.size());
  CHECK_LT(row_idx, num_rows_);
  return reinterpret_cast<float*>(column_buffers_[column_idx])[row_idx];
}

template <>
double ColumnarResultsTester::getEntryAt<double>(const size_t row_idx,
                                                 const size_t column_idx) const {
  CHECK_LT(column_idx, column_buffers_.size());
  CHECK_LT(row_idx, num_rows_);
  return reinterpret_cast<double*>(column_buffers_[column_idx])[row_idx];
}

void test_columnar_conversion(const std::vector<TargetInfo>& target_infos,
                              const QueryMemoryDescriptor& query_mem_desc,
                              const size_t non_empty_step_size,
                              const bool is_parallel_conversion = false) {
  auto row_set_mem_owner =
      std::make_shared<RowSetMemoryOwner>(Executor::getArenaBlockSize());
  ResultSet result_set(
      target_infos, ExecutorDeviceType::CPU, query_mem_desc, row_set_mem_owner, nullptr);

  // fill the storage
  const auto storage = result_set.allocateStorage();
  EvenNumberGenerator generator;
  fill_storage_buffer(storage->getUnderlyingBuffer(),
                      target_infos,
                      query_mem_desc,
                      generator,
                      non_empty_step_size);

  // Columnar Conversion:
  std::vector<SQLTypeInfo> col_types;
  for (size_t i = 0; i < result_set.colCount(); ++i) {
    col_types.push_back(get_logical_type_info(result_set.getColType(i)));
  }
  ColumnarResultsTester columnar_results(
      row_set_mem_owner, result_set, col_types.size(), col_types, is_parallel_conversion);

  // Validate the results:
  for (size_t rs_row_idx = 0, cr_row_idx = 0; rs_row_idx < query_mem_desc.getEntryCount();
       rs_row_idx++) {
    if (result_set.isRowAtEmpty(rs_row_idx)) {
      // empty entries should be filtered out for conversion:
      continue;
    }
    const auto row = result_set.getRowAt(rs_row_idx);
    if (row.empty()) {
      break;
    }
    CHECK_EQ(target_infos.size(), row.size());
    for (size_t target_idx = 0; target_idx < target_infos.size(); ++target_idx) {
      const auto& target_info = target_infos[target_idx];
      const auto& ti = target_info.agg_kind == kAVG ? SQLTypeInfo{kDOUBLE, false}
                                                    : target_info.sql_type;
      switch (ti.get_type()) {
        case kBIGINT: {
          const auto ival_result_set = v<int64_t>(row[target_idx]);
          const auto ival_converted = static_cast<int64_t>(
              columnar_results.getEntryAt<int64_t>(cr_row_idx, target_idx));
          ASSERT_EQ(ival_converted, ival_result_set);
          break;
        }
        case kINT: {
          const auto ival_result_set = v<int64_t>(row[target_idx]);
          const auto ival_converted = static_cast<int64_t>(
              columnar_results.getEntryAt<int32_t>(cr_row_idx, target_idx));
          ASSERT_EQ(ival_converted, ival_result_set);
          break;
        }
        case kSMALLINT: {
          const auto ival_result_set = v<int64_t>(row[target_idx]);
          const auto ival_converted = static_cast<int64_t>(
              columnar_results.getEntryAt<int16_t>(cr_row_idx, target_idx));
          ASSERT_EQ(ival_result_set, ival_converted);
          break;
        }
        case kTINYINT: {
          const auto ival_result_set = v<int64_t>(row[target_idx]);
          const auto ival_converted = static_cast<int64_t>(
              columnar_results.getEntryAt<int8_t>(cr_row_idx, target_idx));
          ASSERT_EQ(ival_converted, ival_result_set);
          break;
        }
        case kFLOAT: {
          const auto fval_result_set = v<float>(row[target_idx]);
          const auto fval_converted =
              columnar_results.getEntryAt<float>(cr_row_idx, target_idx);
          ASSERT_FLOAT_EQ(fval_result_set, fval_converted);
          break;
        }
        case kDOUBLE: {
          const auto dval_result_set = v<double>(row[target_idx]);
          const auto dval_converted =
              columnar_results.getEntryAt<double>(cr_row_idx, target_idx);
          ASSERT_FLOAT_EQ(dval_result_set, dval_converted);
          break;
        }
        default:
          UNREACHABLE() << "Invalid type info encountered.";
      }
    }
    cr_row_idx++;
  }
}

TEST(Construct, Empty) {
  std::vector<TargetInfo> target_infos;
  std::vector<SQLTypeInfo> sql_type_infos;
  QueryMemoryDescriptor query_mem_desc;
  auto row_set_mem_owner =
      std::make_shared<RowSetMemoryOwner>(Executor::getArenaBlockSize());
  ResultSet result_set(
      target_infos, ExecutorDeviceType::CPU, query_mem_desc, row_set_mem_owner, nullptr);
  ColumnarResultsTester columnar_results(
      row_set_mem_owner, result_set, sql_type_infos.size(), sql_type_infos);
}

// Projections:
// TODO(Saman): add tests for Projections

// Perfect Hash:
TEST(PerfectHashRowWise, OneCol_64Key_64Agg_wo_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kMIN, kMAX, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, OneCol_64Key_64Agg_w_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kAVG, kMAX, kAVG, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kDOUBLE, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, OneCol_32Key_64Agg_wo_avg) {
  std::vector<int8_t> key_column_widths{4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kMIN, kMAX, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 3, 17, 33, 117}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, OneCol_32Key_64Agg_w_avg) {
  std::vector<int8_t> key_column_widths{4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kAVG, kCOUNT, kAVG, kMAX, kMIN},
      {kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kDOUBLE, kBIGINT, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 3, 17, 33, 117}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, OneCol_64Key_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kTINYINT, kSMALLINT, kINT, kBIGINT, kFLOAT, kDOUBLE},
      {kTINYINT, kSMALLINT, kINT, kBIGINT, kFLOAT, kDOUBLE});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, OneCol_64Key_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kAVG, kMAX, kMAX, kAVG, kMAX},
      {kTINYINT, kSMALLINT, kINT, kDOUBLE, kBIGINT, kFLOAT, kDOUBLE, kDOUBLE},
      {kTINYINT, kSMALLINT, kINT, kSMALLINT, kBIGINT, kFLOAT, kINT, kDOUBLE});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, OneCol_32Key_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 17, 33, 117}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, OneCol_32Key_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kAVG, kMAX, kMAX, kMAX},
      {kDOUBLE, kDOUBLE, kFLOAT, kBIGINT, kDOUBLE, kINT, kSMALLINT, kTINYINT},
      {kDOUBLE, kDOUBLE, kFLOAT, kBIGINT, kFLOAT, kINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 17, 33, 117}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_64Key_64Agg_w_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kAVG, kMAX, kAVG, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kDOUBLE, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_64Key_64Agg_wo_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos =
      generate_custom_agg_target_infos(key_column_widths,
                                       {kSUM, kSUM, kCOUNT, kMAX, kMIN},
                                       {kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT},
                                       {kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_64Key_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kAVG, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kDOUBLE, kFLOAT, kDOUBLE, kBIGINT, kINT, kDOUBLE, kSMALLINT, kTINYINT},
      {kDOUBLE, kFLOAT, kINT, kBIGINT, kINT, kSMALLINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_64Key_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_32Key_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{4};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kAVG, kAVG, kMAX, kMAX, kMAX, kMAX},
      {kDOUBLE, kFLOAT, kDOUBLE, kDOUBLE, kBIGINT, kINT, kSMALLINT, kTINYINT},
      {kDOUBLE, kFLOAT, kBIGINT, kTINYINT, kBIGINT, kINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_32Key_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{4};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_16Key_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{2};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kMAX, kAVG, kMAX},
      {kDOUBLE, kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kDOUBLE, kTINYINT},
      {kDOUBLE, kINT, kFLOAT, kBIGINT, kINT, kSMALLINT, kBIGINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_16Key_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{2};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_8Key_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{1};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kAVG, kMAX, kAVG, kMAX},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE, kTINYINT},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kINT, kSMALLINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_8Key_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{1};
  const int8_t suggested_agg_width = 1;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT},
      {kDOUBLE, kFLOAT, kBIGINT, kINT, kSMALLINT, kTINYINT});
  auto query_mem_desc =
      perfect_hash_one_col_desc(target_infos, suggested_agg_width, 0, 118);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {3, 7, 16, 37, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

// Multi-column perfect hash:
TEST(PerfectHashRowWise, TwoCol_64_64_64Agg_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kMIN, kMAX, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, TwoCol_64_64_64Agg_w_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kAVG, kMAX, kAVG, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kDOUBLE, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, TwoCol_64_64_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kTINYINT, kSMALLINT, kINT, kBIGINT, kFLOAT, kDOUBLE},
      {kTINYINT, kSMALLINT, kINT, kBIGINT, kFLOAT, kDOUBLE});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashRowWise, TwoCol_64_64_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kAVG, kMAX, kMAX, kAVG, kMAX},
      {kTINYINT, kSMALLINT, kINT, kDOUBLE, kBIGINT, kFLOAT, kDOUBLE, kDOUBLE},
      {kTINYINT, kSMALLINT, kINT, kSMALLINT, kBIGINT, kFLOAT, kINT, kDOUBLE});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, OneCol_TwoCol_64_64_64Agg_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kMIN, kMAX, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kBIGINT});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, TwoCol_64_64_64Agg_w_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kSUM, kSUM, kCOUNT, kAVG, kMAX, kAVG, kMIN},
      {kBIGINT, kBIGINT, kBIGINT, kDOUBLE, kBIGINT, kDOUBLE, kBIGINT},
      {kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT, kBIGINT});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {1, 2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, TwoCol_64_64_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kTINYINT, kSMALLINT, kINT, kBIGINT, kFLOAT, kDOUBLE},
      {kTINYINT, kSMALLINT, kINT, kBIGINT, kFLOAT, kDOUBLE});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(PerfectHashColumnar, TwoCol_64_64_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kAVG, kMAX, kMAX, kAVG, kMAX},
      {kTINYINT, kSMALLINT, kINT, kDOUBLE, kBIGINT, kFLOAT, kDOUBLE, kDOUBLE},
      {kTINYINT, kSMALLINT, kINT, kSMALLINT, kBIGINT, kFLOAT, kINT, kDOUBLE});
  auto query_mem_desc = perfect_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 13, 67, 127}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

// Baseline Hash:
TEST(BaselineHashRowWise, TwoCol_64_64_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1});
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashRowWise, TwoCol_64_64_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kFLOAT, kDOUBLE, kBIGINT, kTINYINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE},
      {kFLOAT, kTINYINT, kBIGINT, kTINYINT, kINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1, -1, -1});
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashRowWise, TwoCol_64_32_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1});
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashRowWise, TwoCol_32_64_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{4, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kFLOAT, kDOUBLE, kBIGINT, kTINYINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE},
      {kFLOAT, kTINYINT, kBIGINT, kTINYINT, kINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1, -1, -1});
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashRowWise, TwoCol_32_32_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{4, 4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1});
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashRowWise, TwoCol_32_32_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{4, 4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kFLOAT, kDOUBLE, kBIGINT, kTINYINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE},
      {kFLOAT, kTINYINT, kBIGINT, kTINYINT, kINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1, -1, -1});
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashColumnar, TwoCol_64_64_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kFLOAT, kDOUBLE, kBIGINT, kTINYINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE},
      {kFLOAT, kTINYINT, kBIGINT, kTINYINT, kINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1, -1, -1});
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashColumnar, TwoCol_64_64_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{8, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kFLOAT, kDOUBLE, kBIGINT, kTINYINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE},
      {kFLOAT, kTINYINT, kBIGINT, kTINYINT, kINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1, -1, -1});
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashColumnar, TwoCol_64_32_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{8, 4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1});
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashColumnar, TwoCol_32_64_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{4, 8};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kFLOAT, kDOUBLE, kBIGINT, kTINYINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE},
      {kFLOAT, kTINYINT, kBIGINT, kTINYINT, kINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1, -1, -1});
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashColumnar, TwoCol_32_32_MixedAggs_wo_avg) {
  std::vector<int8_t> key_column_widths{4, 4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kMAX, kMAX, kMAX, kMAX, kMAX},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE},
      {kFLOAT, kBIGINT, kTINYINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1});
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

TEST(BaselineHashColumnar, TwoCol_32_32_MixedAggs_w_avg) {
  std::vector<int8_t> key_column_widths{4, 4};
  const int8_t suggested_agg_width = 8;
  std::vector<TargetInfo> target_infos = generate_custom_agg_target_infos(
      key_column_widths,
      {kMAX, kAVG, kMAX, kMAX, kMAX, kAVG, kMAX, kMAX},
      {kFLOAT, kDOUBLE, kBIGINT, kTINYINT, kINT, kDOUBLE, kSMALLINT, kDOUBLE},
      {kFLOAT, kTINYINT, kBIGINT, kTINYINT, kINT, kINT, kSMALLINT, kDOUBLE});
  auto query_mem_desc = baseline_hash_two_col_desc(target_infos, suggested_agg_width);
  query_mem_desc.setAllTargetGroupbyIndices({0, 1, -1, -1, -1, -1, -1, -1, -1, -1});
  query_mem_desc.setOutputColumnar(true);
  for (auto is_parallel : {false, true}) {
    for (auto step_size : {2, 3, 5, 13, 67}) {
      test_columnar_conversion(target_infos, query_mem_desc, step_size, is_parallel);
    }
  }
}

int main(int argc, char** argv) {
  g_is_test_env = true;

  TestHelpers::init_logger_stderr_only(argc, argv);
  testing::InitGoogleTest(&argc, argv);

  int err{0};
  try {
    err = RUN_ALL_TESTS();
  } catch (const std::exception& e) {
    LOG(ERROR) << e.what();
  }
  return err;
}