Hive Delete Table error: Specified key was too long; Max Key LENGTH&NB

Source: Internet
Author: User
I have this error when hive deletes a table, and seeing this error should be known as a character set error. But what do I use? ALTER DATABASE hive character set latin1;  After this command changed it to Latin or not, and then I think it is not the hive is a reload, and then still have the last existence of the hive table structure, such as the existence of MySQL data information, so decisively the MySQL inside the hive database deleted, and then re: CREATE Database Hive;alter database hive Character set latin1; then use hive; View the character set, although it shows Latin as it did last time, but you re-enter Hive,drop table Table_name;ok, But your table structure is gone, so use caution.??. /hive-hiveconf hive.root.logger=debug,console   // restart hive   Use this command to restart hive and manipulate the prompt to see detailed error messages.  April 15, 2016:00:54?

Hive Delete Table error: Specified key was too long; Max Key LENGTH&NB

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.