Got it

I am having problems using Hive​

Created: Jul 23, 2019 14:29:38Latest reply: Mar 15, 2022 02:16:53 793 4 0 0 1
  Rewarded HiCoins: 0 (problem resolved)

I am having the following problems when creating a table using the Hive process:

create table cite(id int, name string);
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of object "
org.apache.hadoop.hive.metastoStorageDescriptor@6fdd669a" using statement "INSERT INTO `SDS` (`SD_ID`,`NUM_BUCKETS`,`INPUT_FORMAT`,`LOCATIMPRESSED`,`SERDE_ID`,`OUTPUT_FORMAT`,`CD_ID`) VALUES (?,?,?,?,?,?,?,?)" failed : Field 'IS_STOREDASSUBDIRECTORIES'  isn't have a default value
NestedThrowables:
java.sql.SQLException: Field 'IS_STOREDASSUBDIRECTORIES' doesn't have a default value
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

How should I handle it?

  • x
  • convention:

Featured Answers
songminwang
Created Jul 23, 2019 14:37:19

Hello sir!

Via your question, the reason for the analysis here may be that Hive uses mysql to store metadata. The above problems occur due to the inconsistency of metadata due to some failed operations during the period.
 
Solution

Under mysql, modify the S_STOREDASSUBDIRECTORIES attribute of the HDS in the following table.

ALTER TABLE SDS MODIFY COLUMN IS_STOREDASSUBDIRECTORIES bit(1) NOT NULL default false;
View more
  • x
  • convention:

Saqibaz
Saqibaz Created Mar 15, 2022 02:16:45 (0) (0)
 
user_4237671
user_4237671 Created Mar 15, 2022 06:47:38 (0) (0)
note with thanks  
All Answers
songminwang
songminwang Created Jul 23, 2019 14:37:19

Hello sir!

Via your question, the reason for the analysis here may be that Hive uses mysql to store metadata. The above problems occur due to the inconsistency of metadata due to some failed operations during the period.
 
Solution

Under mysql, modify the S_STOREDASSUBDIRECTORIES attribute of the HDS in the following table.

ALTER TABLE SDS MODIFY COLUMN IS_STOREDASSUBDIRECTORIES bit(1) NOT NULL default false;
View more
  • x
  • convention:

Saqibaz
Saqibaz Created Mar 15, 2022 02:16:45 (0) (0)
 
user_4237671
user_4237671 Created Mar 15, 2022 06:47:38 (0) (0)
note with thanks  
Saqibaz
Saqibaz Created Mar 15, 2022 02:16:53

Good answer
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.