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,
platform string,
deviceInfo string,
version string,
imei string,
app_id string,
code string,
trace string,
timestamp string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';

CREATE TABLE method_count(
method string,
count 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,
platform string,
deviceInfo string,
version string,
imei string,
app_id string,
timestamp string,
response string,
trace string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';

CREATE TABLE tc_response(
method string,
biz_data string,
uid string,
platform string,
deviceInfo string,
version string,
imei string,
app_id string,
timestamp string,
response string,
trace string
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';