rangareddy commented on issue #12673:
URL: https://github.com/apache/hudi/issues/12673#issuecomment-2602142292
Hi @TigerTORA
I have successfully read data from Hive using your code. Could you please
review the Hive query logs to identify any potential issues?
```sql
0: jdbc:hive2://hive-server:10000/default> use my_db;
0: jdbc:hive2://hive-server:10000/default> show tables;
+-----------+
| tab_name |
+-----------+
| hudi_cow |
+-----------+
0: jdbc:hive2://hive-server:10000/default> select * from hudi_cow;
INFO : Compiling
command(queryId=hive_20250120110910_bacc7a57-aabb-467f-93b7-da01cf279020):
select * from hudi_cow
INFO : No Stats for my_db@hudi_cow, Columns: _hoodie_commit_time,
inttolong, longtoint, _hoodie_partition_path, versionid, precomb,
_hoodie_record_key, name, tobedeletedstr, _hoodie_commit_seqno,
_hoodie_file_name, rowid
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema:
Schema(fieldSchemas:[FieldSchema(name:hudi_cow._hoodie_commit_time,
type:string, comment:null), FieldSchema(name:hudi_cow._hoodie_commit_seqno,
type:string, comment:null), FieldSchema(name:hudi_cow._hoodie_record_key,
type:string, comment:null), FieldSchema(name:hudi_cow._hoodie_partition_path,
type:string, comment:null), FieldSchema(name:hudi_cow._hoodie_file_name,
type:string, comment:null), FieldSchema(name:hudi_cow.rowid, type:string,
comment:null), FieldSchema(name:hudi_cow.precomb, type:bigint, comment:null),
FieldSchema(name:hudi_cow.name, type:string, comment:null),
FieldSchema(name:hudi_cow.versionid, type:string, comment:null),
FieldSchema(name:hudi_cow.tobedeletedstr, type:string, comment:null),
FieldSchema(name:hudi_cow.inttolong, type:int, comment:null),
FieldSchema(name:hudi_cow.longtoint, type:bigint, comment:null),
FieldSchema(name:hudi_cow.partitionid, type:string, comment:null)],
properties:null)
INFO : Completed compiling
command(queryId=hive_20250120110910_bacc7a57-aabb-467f-93b7-da01cf279020); Time
taken: 0.31 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing
command(queryId=hive_20250120110910_bacc7a57-aabb-467f-93b7-da01cf279020):
select * from hudi_cow
INFO : Completed executing
command(queryId=hive_20250120110910_bacc7a57-aabb-467f-93b7-da01cf279020); Time
taken: 0.001 seconds
+-------------------------------+--------------------------------+------------------------------+----------------------------------+----------------------------------------------------+-----------------+-------------------+----------------+---------------------+--------------------------+---------------------+---------------------+-----------------------+
| hudi_cow._hoodie_commit_time | hudi_cow._hoodie_commit_seqno |
hudi_cow._hoodie_record_key | hudi_cow._hoodie_partition_path |
hudi_cow._hoodie_file_name | hudi_cow.rowid | hudi_cow.precomb |
hudi_cow.name | hudi_cow.versionid | hudi_cow.tobedeletedstr |
hudi_cow.inttolong | hudi_cow.longtoint | hudi_cow.partitionid |
+-------------------------------+--------------------------------+------------------------------+----------------------------------+----------------------------------------------------+-----------------+-------------------+----------------+---------------------+--------------------------+---------------------+---------------------+-----------------------+
| 20250120110832477 | 20250120110832477_1_0 | row_1
| partitionId=2021/01/01 |
8273822c-3db4-4f41-9369-52a48b289ec9-0_1-68-121_20250120110832477.parquet |
row_1 | 0 | bob | v_0 |
toBeDel0 | 0 | 1000000 |
2021/01/01 |
| 20250120110832477 | 20250120110832477_1_1 | row_2
| partitionId=2021/01/01 |
8273822c-3db4-4f41-9369-52a48b289ec9-0_1-68-121_20250120110832477.parquet |
row_2 | 0 | john | v_0 |
toBeDel0 | 0 | 1000000 |
2021/01/01 |
| 20250120110832477 | 20250120110832477_0_0 | row_3
| partitionId=2021/01/02 |
328f6651-ed04-49db-be45-9c3671bcda8d-0_0-68-120_20250120110832477.parquet |
row_3 | 0 | tom | v_0 |
toBeDel0 | 0 | 1000000 |
2021/01/02 |
+-------------------------------+--------------------------------+------------------------------+----------------------------------+----------------------------------------------------+-----------------+-------------------+----------------+---------------------+--------------------------+---------------------+---------------------+-----------------------+
3 rows selected (1.282 seconds)
0: jdbc:hive2://hive-server:10000/default>
```
I have placed **hudi-hadoop-mr-bundle-1.0.0-rc1.jar** to the hive lib.
```sh
hive@9b304fb95236:/opt/hive$ ls lib/*hudi*
lib/hudi-hadoop-mr-bundle-1.0.0-rc1.jar
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
