Support Questions
Find answers, ask questions, and share your expertise

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"
} ]