[
https://issues.apache.org/jira/browse/HIVE-18504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16334650#comment-16334650
]
Naveen Gangam commented on HIVE-18504:
--------------------------------------
[~tomsmaily] Based on this version string, it appears it is Hive 1.2 version
and not 2.6.3. I am not sure if there is a hive 2.6.3 release? Could you please
double check. This fix is not available in hive 1.x releases.
I have had a chance to try this on my local machine on hive 2.1 release that
has this fix. It appears to be working. What backend DB are you running this
against? Thanks
{code:java}
0: jdbc:hive2://localhost:10000> describe tweets;
INFO : Compiling
command(queryId=hive_20180122094040_03a4b910-9872-4b81-8d07-12114a8908ec):
describe tweets
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name,
type:string, comment:from deserializer), FieldSchema(name:data_type,
type:string, comment:from deserializer), FieldSchema(name:comment, type:string,
comment:from deserializer)], properties:null)
INFO : Completed compiling
command(queryId=hive_20180122094040_03a4b910-9872-4b81-8d07-12114a8908ec); Time
taken: 0.027 seconds
INFO : Executing
command(queryId=hive_20180122094040_03a4b910-9872-4b81-8d07-12114a8908ec):
describe tweets
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing
command(queryId=hive_20180122094040_03a4b910-9872-4b81-8d07-12114a8908ec); Time
taken: 0.014 seconds
INFO : OK
+----------------------------+----------------------------------------------------+----------+--+
| col_name | data_type
| comment |
+----------------------------+----------------------------------------------------+----------+--+
| contributors | string
| |
| coordinates | string
| |
| created_at | string
| |
| entities |
struct<hashtags:array<struct<indices:array<tinyint>,text:string>>,symbols:array<string>,urls:array<string>,user_mentions:array<struct<id:int,id_str:binary,indices:array<tinyint>,name:string,screen_name:string>>>
| |
| favorite_count | tinyint
| |
| favorited | boolean
| |
| filter_level | string
| |
| geo | string
| |
| id | bigint
| |
| id_str | binary
| |
| in_reply_to_screen_name | string
| |
| in_reply_to_status_id | string
| |
| in_reply_to_status_id_str | string
| |
| in_reply_to_user_id | string
| |
| in_reply_to_user_id_str | string
| |
| is_quote_status | boolean
| |
| lang | string
| |
| place | string
| |
| quote_count | tinyint
| |
| reply_count | tinyint
| |
| retweet_count | tinyint
| |
| retweeted | boolean
| |
| retweeted_status |
struct<contributors:string,coordinates:string,created_at:string,display_text_range:array<smallint>,entities:struct<hashtags:array<struct<indices:array<tinyint>,text:string>>,symbols:array<string>,urls:array<struct<display_url:string,expanded_url:string,indices:array<smallint>,url:string>>,user_mentions:array<string>>,extended_tweet:struct<display_text_range:array<smallint>,entities:struct<hashtags:array<struct<indices:array<tinyint>,text:string>>,media:array<struct<display_url:string,expanded_url:string,id:bigint,id_str:binary,indices:array<smallint>,media_url:string,media_url_https:string,sizes:struct<large:struct<h:smallint,resize:string,w:smallint>,medium:struct<h:smallint,resize:string,w:smallint>,small:struct<h:smallint,resize:string,w:smallint>,thumb:struct<h:smallint,resize:string,w:smallint>>,type:string,url:string,video_info:struct<aspect_ratio:array<tinyint>,duration_millis:int,variants:array<struct<bitrate:int,content_type:string,url:string>>>>>,symbols:array<string>,urls:array<string>,user_mentions:array<string>>,extended_entities:struct<media:array<struct<display_url:string,expanded_url:string,id:bigint,id_str:binary,indices:array<smallint>,media_url:string,media_url_https:string,sizes:struct<large:struct<h:smallint,resize:string,w:smallint>,medium:struct<h:smallint,resize:string,w:smallint>,small:struct<h:smallint,resize:string,w:smallint>,thumb:struct<h:smallint,resize:string,w:smallint>>,type:string,url:string,video_info:struct<aspect_ratio:array<tinyint>,duration_millis:int,variants:array<struct<bitrate:int,content_type:string,url:string>>>>>>,full_text:string>,favorite_count:smallint,favorited:boolean,filter_level:string,geo:string,id:bigint,id_str:binary,in_reply_to_screen_name:string,in_reply_to_status_id:string,in_reply_to_status_id_str:string,in_reply_to_user_id:string,in_reply_to_user_id_str:string,is_quote_status:boolean,lang:string,place:string,possibly_sensitive:boolean,quote_count:smallint,reply_count:smallint,retweet_count:smallint,retweeted:boolean,source:string,text:string,truncated:boolean,user:struct<contributors_enabled:boolean,created_at:string,default_profile:boolean,default_profile_image:boolean,description:string,favourites_count:smallint,follow_request_sent:string,followers_count:int,following:string,friends_count:smallint,geo_enabled:boolean,id:int,id_str:binary,is_translator:boolean,lang:string,listed_count:smallint,location:string,name:string,notifications:string,profile_background_color:binary,profile_background_image_url:string,profile_background_image_url_https:string,profile_background_tile:boolean,profile_banner_url:string,profile_image_url:string,profile_image_url_https:string,profile_link_color:binary,profile_sidebar_border_color:binary,profile_sidebar_fill_color:binary,profile_text_color:binary,profile_use_background_image:boolean,protected:boolean,screen_name:string,statuses_count:smallint,time_zone:string,translator_type:string,url:string,utc_offset:smallint,verified:boolean>>
| |
| source | string
| |
| text | string
| |
| timestamp_ms | string
| |
| truncated | boolean
| |
| user |
struct<contributors_enabled:boolean,created_at:string,default_profile:boolean,default_profile_image:boolean,description:string,favourites_count:smallint,follow_request_sent:string,followers_count:smallint,following:string,friends_count:smallint,geo_enabled:boolean,id:int,id_str:string,is_translator:boolean,lang:string,listed_count:tinyint,location:string,name:string,notifications:string,profile_background_color:binary,profile_background_image_url:string,profile_background_image_url_https:string,profile_background_tile:boolean,profile_banner_url:string,profile_image_url:string,profile_image_url_https:string,profile_link_color:binary,profile_sidebar_border_color:binary,profile_sidebar_fill_color:binary,profile_text_color:binary,profile_use_background_image:boolean,protected:boolean,screen_name:string,statuses_count:smallint,time_zone:string,translator_type:string,url:string,utc_offset:smallint,verified:boolean>
| |
+----------------------------+----------------------------------------------------+----------+--+
28 rows selected (0.139 seconds)
0: jdbc:hive2://localhost:10000>
{code}
> Hive is throwing InvalidObjectException(message:Invalid column type name is
> too long.
> -------------------------------------------------------------------------------------
>
> Key: HIVE-18504
> URL: https://issues.apache.org/jira/browse/HIVE-18504
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Jimson K James
> Assignee: Naveen Gangam
> Priority: Major
> Fix For: 2.3.0, 3.0.0
>
> Attachments: hive2.log, tweets.sql
>
>
> Hive 2.6.3 is still throwing InvalidObjectException(message:Invalid column
> type name is too long.
> Please find attached the create table query. For more details please refer to
> HIVE-15249
> {code:java}
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask.
> InvalidObjectException(message:Invalid column type name length 2980 exceeds
> max allowed length 2000, type
> struct<contributors:string,coordinates:string,created_at:string,display_text_range:array<smallint>,entities:struct<hashtags:array<struct<indices:array<tinyint>,text:string>>,symbols:array...
> {code}
>
> {code:java}
> [root@sandbox-hdp hive-json]# hive --version
> Hive 1.2.1000.2.6.3.0-235
> Subversion
> git://ctr-e134-1499953498516-254436-01-000004.hwx.site/grid/0/jenkins/workspace/HDP-parallel-centos6/SOURCES/hive
> -r 5f360bda08bb5489fbb3189b5aeaaf58029ed4b5
> Compiled by jenkins on Mon Oct 30 02:48:31 UTC 2017
> From source with checksum 94298cc1f5f5bf0f3470f3ea2e92d646
> [root@sandbox-hdp hive-json]# beeline
> Beeline version 1.2.1000.2.6.3.0-235 by Apache Hive
> beeline> !connect
> jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
> Connecting to
> jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
> Enter username for
> jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2:
> hive
> Enter password for
> jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2:
> ****
> Connected to: Apache Hive (version 1.2.1000.2.6.3.0-235)
> Driver: Hive JDBC (version 1.2.1000.2.6.3.0-235)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> 0: jdbc:hive2://sandbox-hdp.hortonworks.com:2>
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
