以下是用于创建电商业务表的Hive SQL语句:

CREATE TABLE IF NOT EXISTS ecommerce_table (
  id INT,
  name STRING,
  price DECIMAL(10, 2),
  category STRING,
  description STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE;