CREATE DATABASE IF NOT EXISTS testdb;
use testdb;
CREATE TABLE qa_log(
rest string,
requestUri string,
request string,
response string,
status string,
method string,
uid string,
biz_data string,
code string,
trace string,
timestamp string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';

CREATE TABLE biz_data_count(
method string,
biz_data string,
count string,
timestamp string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';

CREATE TABLE biz_data_response(
method string,
biz_data string,
uid string,
timestamp string,
response string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';