[ https://issues.apache.org/jira/browse/HIVE-4703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13868258#comment-13868258 ]
Andrew Otto commented on HIVE-4703: ----------------------------------- I also have the same problem with an external table when using JSON SerDe. I've tried Cloudera's as well as the one from HCatalog. Both have the same behavior. > Describe on a table returns "from deserializer" for column comments instead > of values supplied in Create Table > -------------------------------------------------------------------------------------------------------------- > > Key: HIVE-4703 > URL: https://issues.apache.org/jira/browse/HIVE-4703 > Project: Hive > Issue Type: Bug > Affects Versions: 0.12.0 > Reporter: Eugene Koifman > Attachments: webhcatMini.sh > > > 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 -- This message was sent by Atlassian JIRA (v6.1.5#6160)