[
https://issues.apache.org/jira/browse/ATLAS-216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Madhan Neethiraj resolved ATLAS-216.
------------------------------------
Resolution: Cannot Reproduce
> UI: showing invalid date and time values for hive table
> -------------------------------------------------------
>
> Key: ATLAS-216
> URL: https://issues.apache.org/jira/browse/ATLAS-216
> Project: Atlas
> Issue Type: Bug
> Affects Versions: 0.6-incubating
> Reporter: Ayub Pathan
> Priority: Major
> Labels: ATLAS-UI-BUGS
> Attachments: Invalid_Timestamps_for_hivetables.png
>
>
> While viewing the hive tables metadata in Atlas UI, I see invalid time values
> for createTime and transient_lastDdlTime entries. Please check the attached
> UI snapshot.
> The same query through API results in correct timestamps. Below is the API
> response.
> {code}
> curl
> http://localhost:21000/api/atlas/entity/f286e5d3-0514-4f28-9cef-373473c9999d
> {"requestId":"qtp186909238-384 -
> 71055c83-f290-4370-a279-24412918fb58","GUID":"f286e5d3-0514-4f28-9cef-373473c9999d","definition":"{\n
>
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"f286e5d3-0514-4f28-9cef-373473c9999d\",\n \"version\":0,\n
> \"typeName\":\"hive_table\"\n },\n \"typeName\":\"hive_table\",\n
> \"values\":{\n \"tableType\":\"MANAGED_TABLE\",\n
> \"name\":\"primary.default.t\",\n \"viewExpandedText\":null,\n
> \"createTime\":1444395991,\n \"description\":null,\n
> \"temporary\":false,\n \"db\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"cca28963-f7b1-44fd-a631-f4b6f3b09612\",\n
> \"version\":0,\n \"typeName\":\"hive_db\"\n },\n
> \"viewOriginalText\":null,\n \"retention\":0,\n \"tableName\":\"t\",\n
> \"columns\":[\n {\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"5f89e208-a9ff-40eb-912b-b4394f8d8c0e\",\n
> \"version\":0,\n \"typeName\":\"hive_column\"\n },\n
> \"typeName\":\"hive_column\",\n \"values\":{\n
> \"comment\":null,\n
> \"qualifiedName\":\"primary.default.t.salary\",\n
> \"type\":\"string\",\n \"name\":\"salary\"\n },\n
> \"traitNames\":[\n \n ],\n \"traits\":{\n \n
> }\n },\n {\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"14870ed2-f596-46a3-9500-c720e559703e\",\n
> \"version\":0,\n \"typeName\":\"hive_column\"\n },\n
> \"typeName\":\"hive_column\",\n \"values\":{\n
> \"comment\":null,\n
> \"qualifiedName\":\"primary.default.t.integer\",\n
> \"type\":\"int\",\n \"name\":\"integer\"\n },\n
> \"traitNames\":[\n \n ],\n \"traits\":{\n \n
> }\n },\n {\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"535e002f-f7ed-4e6e-a363-4cc38ebc3b46\",\n
> \"version\":0,\n \"typeName\":\"hive_column\"\n },\n
> \"typeName\":\"hive_column\",\n \"values\":{\n
> \"comment\":null,\n
> \"qualifiedName\":\"primary.default.t.number\",\n
> \"type\":\"int\",\n \"name\":\"number\"\n },\n
> \"traitNames\":[\n \n ],\n \"traits\":{\n \n
> }\n }\n ],\n \"comment\":null,\n \"lastAccessTime\":0,\n
> \"owner\":\"apathan\",\n \"sd\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"168ba76f-c5db-4398-bded-ed25bb626785\",\n
> \"version\":0,\n \"typeName\":\"hive_storagedesc\"\n },\n
> \"typeName\":\"hive_storagedesc\",\n \"values\":{\n
> \"location\":\"hdfs:\/\/localhost:9000\/user\/hive\/warehouse\/t\",\n
> \"serdeInfo\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Struct\",\n
> \"typeName\":\"hive_serde\",\n \"values\":{\n
> \"serializationLib\":\"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe\",\n
> \"parameters\":{\n \"serialization.format\":\"1\"\n
> },\n \"name\":null\n }\n },\n
> \"qualifiedName\":\"primary.default.t\",\n
> \"outputFormat\":\"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat\",\n
> \"compressed\":false,\n \"sortCols\":null,\n
> \"bucketCols\":null,\n \"numBuckets\":-1,\n
> \"inputFormat\":\"org.apache.hadoop.mapred.TextInputFormat\",\n
> \"parameters\":null,\n \"cols\":[\n {\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"5f89e208-a9ff-40eb-912b-b4394f8d8c0e\",\n
> \"version\":0,\n \"typeName\":\"hive_column\"\n },\n
> \"typeName\":\"hive_column\",\n \"values\":{\n
> \"comment\":null,\n
> \"qualifiedName\":\"primary.default.t.salary\",\n
> \"type\":\"string\",\n \"name\":\"salary\"\n },\n
> \"traitNames\":[\n \n ],\n
> \"traits\":{\n \n }\n },\n {\n
>
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"14870ed2-f596-46a3-9500-c720e559703e\",\n
> \"version\":0,\n \"typeName\":\"hive_column\"\n },\n
> \"typeName\":\"hive_column\",\n \"values\":{\n
> \"comment\":null,\n
> \"qualifiedName\":\"primary.default.t.integer\",\n
> \"type\":\"int\",\n \"name\":\"integer\"\n },\n
> \"traitNames\":[\n \n ],\n
> \"traits\":{\n \n }\n },\n {\n
>
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Reference\",\n
> \"id\":{\n
> \"jsonClass\":\"org.apache.atlas.typesystem.json.InstanceSerialization$_Id\",\n
> \"id\":\"535e002f-f7ed-4e6e-a363-4cc38ebc3b46\",\n
> \"version\":0,\n \"typeName\":\"hive_column\"\n },\n
> \"typeName\":\"hive_column\",\n \"values\":{\n
> \"comment\":null,\n
> \"qualifiedName\":\"primary.default.t.number\",\n
> \"type\":\"int\",\n \"name\":\"number\"\n },\n
> \"traitNames\":[\n \n ],\n
> \"traits\":{\n \n }\n }\n ],\n
> \"storedAsSubDirectories\":false\n },\n \"traitNames\":[\n
> \n ],\n \"traits\":{\n \n }\n },\n
> \"parameters\":{\n \"rawDataSize\":\"0\",\n \"numFiles\":\"1\",\n
> \"transient_lastDdlTime\":\"1444395991\",\n \"totalSize\":\"0\",\n
> \"COLUMN_STATS_ACCURATE\":\"true\",\n \"numRows\":\"0\"\n },\n
> \"partitionKeys\":null\n },\n \"traitNames\":[\n \n ],\n
> \"traits\":{\n \n }\n}"}
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
