Member since
10-10-2018
2
Posts
1
Kudos Received
0
Solutions
10-11-2018
11:53 AM
HIVE-20593 it has issue type Bug but I dont understand is this bug fixed? I did not find any soluition for the above issue. > Load Data for partitioned ACID tables fails with bucketId out of range: -1
> --------------------------------------------------------------------------
>
> Key: HIVE-20593
> URL: https://issues.apache.org/jira/browse/HIVE-20593
> Project: Hive
> Issue Type: Bug
> Components: Transactions
> Affects Versions: 3.1.0
> Reporter: Deepak Jaiswal
> Assignee: Deepak Jaiswal
> Priority: Major
> Attachments: HIVE-20593.1.patch, HIVE-20593.2.patch, HIVE-20593.3.patch
>
>
> Load data for ACID tables is failing to load ORC files when it is converted to IAS job.
>
> The tempTblObj is inherited from target table. However, the only table property which
needs to be inherited is bucketing version. Properties like transactional etc should be ignored.
... View more
10-10-2018
06:20 PM
1 Kudo
when i have tried to push data from pyspark to hive..table is creating successfully but when i execute select query from hive on the table i am getting following error and in result getting empty columns Error: java.io.IOException: java.lang.IllegalArgumentException: bucketId out of range: -1 (state=,code=0) I am using Apache Ambari version 2.7.0.0 here are the properties of hive table: +------------------------------------+----------------------------------------------------+
| prpt_name | prpt_value |
+------------------------------------+----------------------------------------------------+
| bucketing_version | 2 |
| numFiles | 56 |
| spark.sql.create.version | 2.3.1.3.0.1.0-187 |
| spark.sql.sources.provider | orc |
| spark.sql.sources.schema.numParts | 1 |
| spark.sql.sources.schema.part.0 | {"type":"struct","fields":[{"name":"SERVICENAME","type":"string","nullable":true,"metadata":{}}]} |
| totalSize | 16675 |
| transactional | true |
| transient_lastDdlTime | 1539170912 |
+------------------------------------+----------------------------------------------------+
... View more
Labels:
- Labels:
-
Apache Hive