flink-end-to-end-tests/flink-tpch-test/src/main/java/org/apache/flink/table/tpch/TpchDataGenerator.java

/*
 * 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.
 */

package org.apache.flink.table.tpch;

import io.airlift.tpch.TpchEntity;
import io.airlift.tpch.TpchTable;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;

/** TPC-H test data generator. */
public class TpchDataGenerator {

    public static final int QUERY_NUM = 22;

    public static void main(String[] args) throws IOException {
        if (args.length != 2) {
            System.out.println("Exactly 1 double value and 1 path should be provided as argument");
            return;
        }

        double scale = Double.valueOf(args[0]);
        String path = args[1];
        generateTable(scale, path);
        generateQuery(path);
        generateExpected(path);
    }

    private static void generateTable(double scale, String path) throws IOException {
        File dir = new File(path + "/table");
        dir.mkdir();

        for (TpchTable table : TpchTable.getTables()) {
            Iterable generator = table.createGenerator(scale, 1, 1);

            StringBuilder builder = new StringBuilder();
            generator.forEach(
                    s -> {
                        String line = ((TpchEntity) s).toLine().trim();
                        if (line.endsWith("|")) {
                            line = line.substring(0, line.length() - 1);
                        }
                        builder.append(line).append('\n');
                    });

            try (BufferedWriter writer =
                    new BufferedWriter(
                            new OutputStreamWriter(
                                    new FileOutputStream(
                                            path + "/table/" + table.getTableName() + ".csv")))) {
                writer.write(builder.toString());
            }
        }
    }

    private static void generateQuery(String path) throws IOException {
        File dir = new File(path + "/query");
        dir.mkdir();

        for (int i = 0; i < QUERY_NUM; i++) {
            try (InputStream in =
                            TpchDataGenerator.class.getResourceAsStream(
                                    "/io/airlift/tpch/queries/q" + (i + 1) + ".sql");
                    OutputStream out = new FileOutputStream(path + "/query/q" + (i + 1) + ".sql")) {
                byte[] buffer = new byte[4096];
                int bytesRead = 0;
                while ((bytesRead = in.read(buffer)) > 0) {
                    out.write(buffer, 0, bytesRead);
                }
            }
        }
    }

    private static void generateExpected(String path) throws IOException {
        File dir = new File(path + "/expected");
        dir.mkdir();

        for (int i = 0; i < QUERY_NUM; i++) {
            try (BufferedReader reader =
                            new BufferedReader(
                                    new InputStreamReader(
                                            TpchDataGenerator.class.getResourceAsStream(
                                                    "/io/airlift/tpch/queries/q"
                                                            + (i + 1)
                                                            + ".result")));
                    BufferedWriter writer =
                            new BufferedWriter(
                                    new OutputStreamWriter(
                                            new FileOutputStream(
                                                    path + "/expected/q" + (i + 1) + ".csv")))) {
                int lineNumber = 0;
                String line;
                while ((line = reader.readLine()) != null) {
                    line = line.trim().replace("null", "");
                    lineNumber++;
                    if (lineNumber == 1) {
                        continue;
                    }
                    if (line.length() > 0 && line.endsWith("|")) {
                        line = line.substring(0, line.length() - 1);
                    }
                    writer.write(line + "\n");
                }
            }
        }
    }
}