Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cloudera Navigator Rest API - Last Modified Not Populated

Cloudera Navigator Rest API - Last Modified Not Populated

New Contributor
In the Cloudera Navigator REST API, the metadata output of the rest API consists of an attribute called "lastModified" which gives information about the last modified timestamp.
 
But in our instance, the last modified value is not populated instead it is returning as null. Can any one help us why last modified filed is not getting updated
 
 
[ {
  "originalName" : "test_table",
  "originalDescription" : "This is test table",
  "sourceId" : "12",
  "firstClassParentId" : null,
  "parentPath" : "/default",
  "deleteTime" : null,
  "extractorRunId" : "12##66",
  "customProperties" : null,
  "name" : null,
  "description" : null,
  "tags" : null,
  "properties" : {
    "__cloudera_internal__hueLink" : "http://cloudera630:8889/hue/metastore/table/default/test_table"
  },
  "technicalProperties" : null,
  "created" : "2020-02-04T08:09:09.000Z",
  "lastAccessed" : "1970-01-01T00:00:00.000Z",
  "lastModified" : null,
  "lastModifiedBy" : null,
  "type" : "TABLE",
  "fileSystemPath" : "hdfs://cloudera630:8020/user/hive/warehouse/test_table",
  "inputFormat" : "org.apache.hadoop.mapred.TextInputFormat",
  "outputFormat" : "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
  "partColNames" : null,
  "clusteredByColNames" : null,
  "sortByColNames" : null,
  "serdeName" : null,
  "serdeLibName" : "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
  "serdeProps" : null,
  "owner" : "admin",
  "compressed" : false,
  "sourceType" : "HIVE",
  "metaClassName" : "hv_table",
  "deleted" : false,
  "userEntity" : false,
  "packageName" : "nav",
  "identity" : "21583",
  "internalType" : "hv_table"
}, {
  "originalName" : "test_table_1",
  "originalDescription" : "This is test table",
  "sourceId" : "12",
  "firstClassParentId" : null,
  "parentPath" : "/default",
  "deleteTime" : null,
  "extractorRunId" : "12##296",
  "customProperties" : null,
  "name" : null,
  "description" : null,
  "tags" : null,
  "properties" : {
    "__cloudera_internal__hueLink" : "http://cloudera630:8889/hue/metastore/table/default/test_table_1"
  },
  "technicalProperties" : null,
  "created" : "2020-03-03T06:57:59.000Z",
  "lastAccessed" : "1970-01-01T00:00:00.000Z",
  "lastModified" : null,
  "lastModifiedBy" : null,
  "type" : "TABLE",
  "fileSystemPath" : "hdfs://cloudera630:8020/user/hive/warehouse/test_table_1",
  "inputFormat" : "org.apache.hadoop.mapred.TextInputFormat",
  "outputFormat" : "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
  "partColNames" : null,
  "clusteredByColNames" : null,
  "sortByColNames" : null,
  "serdeName" : null,
  "serdeLibName" : "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
  "serdeProps" : null,
  "owner" : "admin",
  "compressed" : false,
  "sourceType" : "HIVE",
  "metaClassName" : "hv_table",
  "deleted" : false,
  "userEntity" : false,
  "packageName" : "nav",
  "identity" : "91408",
  "internalType" : "hv_table"
}, {
  "originalName" : "pk",
  "originalDescription" : null,
  "sourceId" : "12",
  "firstClassParentId" : null,
  "parentPath" : "/default",
  "deleteTime" : null,
  "extractorRunId" : "12##659",
  "customProperties" : null,
  "name" : null,
  "description" : null,
  "tags" : null,
  "properties" : {
    "__cloudera_internal__hueLink" : "http://cloudera630:8889/hue/metastore/table/default/pk"
  },
  "technicalProperties" : {
    "numFilesErasureCoded" : "0"
  },
  "created" : "2020-03-13T09:57:13.000Z",
  "lastAccessed" : "1970-01-01T00:00:00.000Z",
  "lastModified" : null,
  "lastModifiedBy" : null,
  "type" : "TABLE",
  "fileSystemPath" : "hdfs://cloudera630:8020/user/hive/warehouse/pk",
  "inputFormat" : "org.apache.hadoop.mapred.TextInputFormat",
  "outputFormat" : "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
  "partColNames" : null,
  "clusteredByColNames" : null,
  "sortByColNames" : null,
  "serdeName" : null,
  "serdeLibName" : "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
  "serdeProps" : null,
  "owner" : "admin",
  "compressed" : false,
  "sourceType" : "HIVE",
  "metaClassName" : "hv_table",
  "deleted" : false,
  "userEntity" : false,
  "packageName" : "nav",
  "identity" : "1288004",
  "internalType" : "hv_table"
}, {
  "originalName" : "fk",
  "originalDescription" : null,
  "sourceId" : "12",
  "firstClassParentId" : null,
  "parentPath" : "/default",
  "deleteTime" : null,
  "extractorRunId" : "12##659",
  "customProperties" : null,
  "name" : null,
  "description" : "Test Table description",
  "tags" : null,
  "properties" : {
    "__cloudera_internal__hueLink" : "http://cloudera630:8889/hue/metastore/table/default/fk"
  },
  "technicalProperties" : {
    "numFilesErasureCoded" : "0"
  },
  "created" : "2020-03-13T09:58:48.000Z",
  "lastAccessed" : "1970-01-01T00:00:00.000Z",
  "lastModified" : null,
  "lastModifiedBy" : null,
  "type" : "TABLE",
  "fileSystemPath" : "hdfs://cloudera630:8020/user/hive/warehouse/fk",
  "inputFormat" : "org.apache.hadoop.mapred.TextInputFormat",
  "outputFormat" : "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat",
  "partColNames" : null,
  "clusteredByColNames" : null,
  "sortByColNames" : null,
  "serdeName" : null,
  "serdeLibName" : "org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe",
  "serdeProps" : null,
  "owner" : "admin",
  "compressed" : false,
  "sourceType" : "HIVE",
  "metaClassName" : "hv_table",
  "deleted" : false,
  "userEntity" : false,
  "packageName" : "nav",
  "identity" : "1288001",
  "internalType" : "hv_table"
} ]
Don't have an account?
Coming from Hortonworks? Activate your account here