[HIVE-4703] Describe on a table returns "from deserializer" for column comments instead of values supplied in Create Table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.13.0
• Assignee: Ashutosh Chauhan
• Reporter: Eugene Koifman
• Created: 11/Jun/13 00:18
• Updated: 21/Mar/14 04:27
• Resolved: 21/Mar/14 04:27

Description

This causes Templeton e2e tests to fail.

start WeHcat server (build/dist/hcatalog/sbin/webhcat_server.sh start)

run commands in the attached webhcatMini.sh.
It creates a table with some comments on columns.

When executing describe (GET) on this table, original comments are lost and are replaced with "from deserializer" string.

Here is the output of these commands:

localhost:dev ekoifman$ webhcatMini.sh
Running delete test_table ifExists
HTTP/1.1 200 OK
Set-Cookie: hadoop.auth="u=ekoifman&p=ekoifman&t=simple&e=1370945567179&s=vIBKhGQwzs5pPAY3IkhyPpDkWrY=";Version=1;Path=/;Discard
Expires: Thu, 01 Jan 1970 00:00:00 GMT
Content-Type: application/json
Transfer-Encoding: chunked
Server: Jetty(7.6.0.v20120127)

{"table":"test_table","database":"default"}

Running create test_table
HTTP/1.1 200 OK
Set-Cookie: hadoop.auth="u=ekoifman&p=ekoifman&t=simple&e=1370945569788&s=g37NbyyRnf667IciUiIpIQNYGOo=";Version=1;Path=/;Discard
Expires: Thu, 01 Jan 1970 00:00:00 GMT
Content-Type: application/json
Transfer-Encoding: chunked
Server: Jetty(7.6.0.v20120127)

{"table":"test_table","database":"default"}

Running describe test_table
HTTP/1.1 200 OK
Set-Cookie: hadoop.auth="u=ekoifman&p=ekoifman&t=simple&e=1370945572423&s=7kE1FOn1Co2JQzZfW0V1myqulw0=";Version=1;Path=/;Discard
Expires: Thu, 01 Jan 1970 00:00:00 GMT
Content-Type: application/json
Transfer-Encoding: chunked
Server: Jetty(7.6.0.v20120127)

{"columns":[

{"name":"int","comment":"from deserializer","type":"string"}

,

{"name":"int2","comment":"from deserializer","type":"int"}

],"database":"default","table":"test_table"}

Mon Jun 10 17:12:55 PDT 2013

Issue Links

• is related to: HIVE-4814 Adjust WebHCat e2e tests until HIVE-4703 is addressed
• relates to: HIVE-4449 show create table method returns only "COMMENT 'from deserializer'"