```sql
CREATE DATABASE IF NOT EXISTS test_db; -- 创建数据库test_db
USE test_db; -- 使用数据库test_db
1.
2.
3.
### 步骤3:创建表
```markdown
```sql
CREATE EXTERNAL TABLE IF NOT EXISTS test_table (
id INT,
name STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION '/user/hive/warehouse/test_db.db/test_table'; -- 创建表test_table
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
### 步骤4:导入数据
```markdown
```sql
LOAD DATA LOCAL INPATH '/path/to/your/data.txt'
OVERWRITE INTO TABLE test_table; -- 导入数据到test_table
1.
2.
3.
4.
5.
6.
7.
### 步骤5:删除换行符
```markdown
```sql
CREATE TABLE test_table_no_newline AS
SELECT
id,
regexp_replace(name, '\\n', '') AS name
FROM test_table; -- 创建新表test_table_no_newline并删除换行符