AwasthiSomesh commented on issue #11297: URL: https://github.com/apache/iceberg/issues/11297#issuecomment-2405540280
@nastra Select query like below .
val df = spark.sql("select * from iceberg1table2");
Create Table Syntax:-
CREATE TABLE iceberg1table2( l_orderkey int,
data string,
l_partkey string)
STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'
LOCATION 'abfss://location/iceberg1table2'
TBLPROPERTIES ('iceberg.catalog'='location_based_table');
Insert into:-
insert into iceberg1table2 values (1,'somesh','somesh');
Desc Formatted:
+-------------------------------+----------------------------------------------------+----------------------------------------------------+
| col_name | data_type
| comment |
+-------------------------------+----------------------------------------------------+----------------------------------------------------+
| l_orderkey | int
| |
| data | string
| |
| l_partkey | string
| |
| | NULL
| NULL |
| # Detailed Table Information | NULL
| NULL |
| Database: | default
| NULL |
| OwnerType: | USER
| NULL |
| Owner: | hive
| NULL |
| CreateTime: | Thu Oct 03 06:26:50 UTC 2024
| NULL |
| LastAccessTime: | UNKNOWN
| NULL |
| Retention: | 0
| NULL |
| Location: | abfss://location/iceberg1table2 | NULL
|
| Table Type: | EXTERNAL_TABLE
| NULL |
| Table Parameters: | NULL
| NULL |
| | COLUMN_STATS_ACCURATE
|
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"data\":\"true\",\"l_orderkey\":\"true\",\"l_partkey\":\"true\"}}
|
| | EXTERNAL
| TRUE |
| | TRANSLATED_TO_EXTERNAL
| TRUE |
| | bucketing_version
| 2 |
| | current-snapshot-id
| 5438826129807039302 |
| | external.table.purge
| TRUE |
| | format-version
| 2 |
| | iceberg.catalog
| location_based_table |
| | iceberg.orc.files.only
| false |
| | numFiles
| 0 |
| | numRows
| 0 |
| | rawDataSize
| 0 |
| | storage_handler
| org.apache.iceberg.mr.hive.HiveIcebergStorageHandler |
| | table_type
| ICEBERG |
| | totalSize
| 0 |
| | transient_lastDdlTime
| 1727936898 |
| | NULL
| NULL |
| # Storage Information | NULL
| NULL |
| SerDe Library: |
org.apache.iceberg.mr.hive.HiveIcebergSerDe | NULL
|
| InputFormat: |
org.apache.iceberg.mr.hive.HiveIcebergInputFormat | NULL
|
| OutputFormat: |
org.apache.iceberg.mr.hive.HiveIcebergOutputFormat | NULL
|
| Compressed: | No
| NULL |
| Sort Columns: | []
| NULL |
| Storage Desc Params: | NULL
| NULL |
| | serialization.format
| 1 |
+-------------------------------+----------------------------------------------------+----------------------------------------------------+
39 rows selected (3.047 seconds)
0: jdbc:hive2://localhost:10000/>
--
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: issues-unsubscr...@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org
