Github user jackylk commented on a diff in the pull request:
https://github.com/apache/carbondata/pull/1572#discussion_r153137101
--- Diff:
integration/spark2/src/main/scala/org/apache/spark/sql/execution/command/schema/GetTableDetailCommand.scala
---
@@ -0,0 +1,81 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.spark.sql.execution.command.schema
+
+import org.apache.spark.sql.{CarbonEnv, Row, SparkSession}
+import org.apache.spark.sql.catalyst.expressions.{Attribute,
AttributeReference}
+import org.apache.spark.sql.execution.command.{DataProcessCommand,
RunnableCommand}
+import org.apache.spark.sql.types.{LongType, StringType}
+
+import org.apache.carbondata.core.constants.CarbonCommonConstants
+import org.apache.carbondata.core.metadata.schema.table.CarbonTable
+import org.apache.carbondata.core.metadata.AbsoluteTableIdentifier
+import org.apache.carbondata.core.statusmanager.SegmentStatusManager
+import org.apache.carbondata.core.util.{CarbonProperties, CarbonUtil}
+
+/**
+ * collect dynamic detail information of the table, including table size,
last modified time, etc.
+ */
+case class GetTableDetailCommand(
+ databaseName: String,
+ tableNames: Seq[String])
+ extends RunnableCommand with DataProcessCommand {
+
+ override def run(sparkSession: SparkSession): Seq[Row] = {
+ processData(sparkSession)
+ }
+
+ override def processData(sparkSession: SparkSession): Seq[Row] = {
+ val storePath = CarbonProperties.getStorePath
+ tableNames.map { tablename =>
+ val absoluteTableIdentifier =
+ AbsoluteTableIdentifier.from(storePath, databaseName.toLowerCase,
tablename.toLowerCase)
+ val carbonTableIdentifier =
absoluteTableIdentifier.getCarbonTableIdentifier
+ val carbonTable =
CarbonEnv.getCarbonTable(Option(carbonTableIdentifier.getDatabaseName),
+ carbonTableIdentifier.getTableName)(sparkSession)
+
+ Row(
+ tablename,
+ getSizeInBytes(sparkSession, carbonTable),
+ getLastModifiedTime(absoluteTableIdentifier)
+ )
+ }
+ }
+
+ private def getLastModifiedTime(absoluteTableIdentifier:
AbsoluteTableIdentifier): Long = {
+
SegmentStatusManager.getTableStatusLastModifiedTime(absoluteTableIdentifier)
+ }
+
+ private def getSizeInBytes(
--- End diff --
Add this in CarbonTable class
---
