表创建：

create table t1 (id int,name string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

查询：

select * from t1 where name like 'r%';

输出：

1 ram
   2 rahim

您可以运行相同的查询。
Hive>

CREATE TABLE t1(
 id int, 
 name string)
 ROW FORMAT DELIMITED 
 FIELDS TERMINATED BY ',' 
 LINES TERMINATED BY '\n';

正常时间：0.625秒

hive> load data local inpath '/home/amit/data.txt' into table t1;

正在将数据加载到表eis\ U app.t1表eis\ U app.t1统计：[numfiles=1，totalsize=44]确定所用时间：1.22秒

hive> select * from t1;

OK
1   ram
2   rahim 
3   yesudas
4   george 
5   yogesh
Time taken: 0.098 seconds, Fetched: 5 row(s)

hive> select * from t1 where name like 'r%';

    OK
    1   ram
    2   rahim 
    Time taken: 0.107 seconds, Fetched: 2 row(s)
    hive>