Class

org.apache.spark.sql.execution.command

ShowTablesCommand

Related Doc: package command

Permalink

case class ShowTablesCommand(databaseName: Option[String], tableIdentifierPattern: Option[String], isExtended: Boolean = false, partitionSpec: Option[TablePartitionSpec] = None) extends LeafNode with RunnableCommand with Product with Serializable

A command for users to get tables in the given database. If a databaseName is not given, the current database will be used. The syntax of using this command in SQL is:

SHOW TABLES [(IN|FROM) database_name] [[LIKE] 'identifier_with_wildcards'];
SHOW TABLE EXTENDED [(IN|FROM) database_name] LIKE 'identifier_with_wildcards'
[PARTITION(partition_spec)];
Linear Supertypes
Serializable, Serializable, RunnableCommand, Command, LeafNode, LogicalPlan, Logging, QueryPlan[LogicalPlan], TreeNode[LogicalPlan], Product, Equals, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. ShowTablesCommand
  2. Serializable
  3. Serializable
  4. RunnableCommand
  5. Command
  6. LeafNode
  7. LogicalPlan
  8. Logging
  9. QueryPlan
  10. TreeNode
  11. Product
  12. Equals
  13. AnyRef
  14. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Instance Constructors

  1. new ShowTablesCommand(databaseName: Option[String], tableIdentifierPattern: Option[String], isExtended: Boolean = false, partitionSpec: Option[TablePartitionSpec] = None)

    Permalink

Value Members

  1. final def !=(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any

  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any

  3. final def ==(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any

  4. lazy val allAttributes: AttributeSeq

    Permalink
    Definition Classes
    QueryPlan

  5. def analyzed: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  6. def apply(number: Int): TreeNode[_]

    Permalink
    Definition Classes
    TreeNode

  7. def argString: String

    Permalink
    Definition Classes
    TreeNode

  8. def asCode: String

    Permalink
    Definition Classes
    TreeNode

  9. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any

  10. lazy val canonicalized: LogicalPlan

    Permalink
    Definition Classes
    QueryPlan

  11. final def children: Seq[LogicalPlan]

    Permalink
    Definition Classes
    LeafNode → TreeNode

  12. def childrenResolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  13. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  14. def collect[B](pf: PartialFunction[LogicalPlan, B]): Seq[B]

    Permalink
    Definition Classes
    TreeNode

  15. def collectFirst[B](pf: PartialFunction[LogicalPlan, B]): Option[B]

    Permalink
    Definition Classes
    TreeNode

  16. def collectLeaves(): Seq[LogicalPlan]

    Permalink
    Definition Classes
    TreeNode

  17. def computeStats(conf: SQLConf): Statistics

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan

  18. lazy val constraints: ExpressionSet

    Permalink
    Definition Classes
    QueryPlan

  19. lazy val containsChild: Set[TreeNode[_]]

    Permalink
    Definition Classes
    TreeNode

  20. val databaseName: Option[String]

    Permalink

  21. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef

  22. final def expressions: Seq[Expression]

    Permalink
    Definition Classes
    QueryPlan

  23. def fastEquals(other: TreeNode[_]): Boolean

    Permalink
    Definition Classes
    TreeNode

  24. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  25. def find(f: (LogicalPlan) ⇒ Boolean): Option[LogicalPlan]

    Permalink
    Definition Classes
    TreeNode

  26. def flatMap[A](f: (LogicalPlan) ⇒ TraversableOnce[A]): Seq[A]

    Permalink
    Definition Classes
    TreeNode

  27. def foreach(f: (LogicalPlan) ⇒ Unit): Unit

    Permalink
    Definition Classes
    TreeNode

  28. def foreachUp(f: (LogicalPlan) ⇒ Unit): Unit

    Permalink
    Definition Classes
    TreeNode

  29. def generateTreeString(depth: Int, lastChildren: Seq[Boolean], builder: StringBuilder, verbose: Boolean, prefix: String, addSuffix: Boolean): StringBuilder

    Permalink
    Definition Classes
    TreeNode

  30. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any

  31. def getRelevantConstraints(constraints: Set[Expression]): Set[Expression]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  32. def hashCode(): Int

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any

  33. def initializeLogIfNecessary(isInterpreter: Boolean): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  34. def innerChildren: Seq[QueryPlan[_]]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan → TreeNode

  35. def inputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  36. final def invalidateStatsCache(): Unit

    Permalink
    Definition Classes
    LogicalPlan

  37. val isExtended: Boolean

    Permalink

  38. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any

  39. def isStreaming: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  40. def isTraceEnabled(): Boolean

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  41. def jsonFields: List[JField]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  42. def log: Logger

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  43. def logDebug(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  44. def logDebug(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  45. def logError(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  46. def logError(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  47. def logInfo(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  48. def logInfo(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  49. def logName: String

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  50. def logTrace(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  51. def logTrace(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  52. def logWarning(msg: ⇒ String, throwable: Throwable): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  53. def logWarning(msg: ⇒ String): Unit

    Permalink
    Attributes
    protected
    Definition Classes
    Logging

  54. def makeCopy(newArgs: Array[AnyRef]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  55. def map[A](f: (LogicalPlan) ⇒ A): Seq[A]

    Permalink
    Definition Classes
    TreeNode

  56. def mapChildren(f: (LogicalPlan) ⇒ LogicalPlan): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  57. def mapExpressions(f: (Expression) ⇒ Expression): ShowTablesCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  58. def mapProductIterator[B](f: (Any) ⇒ B)(implicit arg0: ClassTag[B]): Array[B]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  59. def maxRows: Option[Long]

    Permalink
    Definition Classes
    LogicalPlan

  60. def missingInput: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  61. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef

  62. def nodeName: String

    Permalink
    Definition Classes
    TreeNode

  63. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef

  64. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef

  65. def numberedTreeString: String

    Permalink
    Definition Classes
    TreeNode

  66. val origin: Origin

    Permalink
    Definition Classes
    TreeNode

  67. def otherCopyArgs: Seq[AnyRef]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  68. val output: Seq[Attribute]

    Permalink
    Definition Classes
    ShowTablesCommand → Command → QueryPlan

  69. def outputSet: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  70. def p(number: Int): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  71. val partitionSpec: Option[TablePartitionSpec]

    Permalink

  72. def preCanonicalized: LogicalPlan

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  73. def prettyJson: String

    Permalink
    Definition Classes
    TreeNode

  74. def printSchema(): Unit

    Permalink
    Definition Classes
    QueryPlan

  75. def producedAttributes: AttributeSet

    Permalink
    Definition Classes
    LeafNode → QueryPlan

  76. def references: AttributeSet

    Permalink
    Definition Classes
    QueryPlan

  77. def refresh(): Unit

    Permalink
    Definition Classes
    LogicalPlan

  78. def resolve(nameParts: Seq[String], input: Seq[Attribute], resolver: Resolver): Option[NamedExpression]

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan

  79. def resolve(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan

  80. def resolve(schema: StructType, resolver: Resolver): Seq[Attribute]

    Permalink
    Definition Classes
    LogicalPlan

  81. def resolveChildren(nameParts: Seq[String], resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan

  82. def resolveExpressions(r: PartialFunction[Expression, Expression]): LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan

  83. def resolveOperators(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    LogicalPlan

  84. def resolveQuoted(name: String, resolver: Resolver): Option[NamedExpression]

    Permalink
    Definition Classes
    LogicalPlan

  85. lazy val resolved: Boolean

    Permalink
    Definition Classes
    LogicalPlan

  86. def run(sparkSession: SparkSession): Seq[Row]

    Permalink
    Definition Classes
    ShowTablesCommand → RunnableCommand

  87. final def sameResult(other: LogicalPlan): Boolean

    Permalink
    Definition Classes
    QueryPlan

  88. lazy val schema: StructType

    Permalink
    Definition Classes
    QueryPlan

  89. def schemaString: String

    Permalink
    Definition Classes
    QueryPlan

  90. final def semanticHash(): Int

    Permalink
    Definition Classes
    QueryPlan

  91. def simpleString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode

  92. def statePrefix: String

    Permalink
    Attributes
    protected
    Definition Classes
    LogicalPlan → QueryPlan

  93. final def stats(conf: SQLConf): Statistics

    Permalink
    Definition Classes
    LogicalPlan

  94. def stringArgs: Iterator[Any]

    Permalink
    Attributes
    protected
    Definition Classes
    TreeNode

  95. def subqueries: Seq[LogicalPlan]

    Permalink
    Definition Classes
    QueryPlan

  96. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef

  97. val tableIdentifierPattern: Option[String]

    Permalink

  98. def toJSON: String

    Permalink
    Definition Classes
    TreeNode

  99. def toString(): String

    Permalink
    Definition Classes
    TreeNode → AnyRef → Any

  100. def transform(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  101. def transformAllExpressions(rule: PartialFunction[Expression, Expression]): ShowTablesCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  102. def transformDown(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  103. def transformExpressions(rule: PartialFunction[Expression, Expression]): ShowTablesCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  104. def transformExpressionsDown(rule: PartialFunction[Expression, Expression]): ShowTablesCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  105. def transformExpressionsUp(rule: PartialFunction[Expression, Expression]): ShowTablesCommand.this.type

    Permalink
    Definition Classes
    QueryPlan

  106. def transformUp(rule: PartialFunction[LogicalPlan, LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

  107. def treeString(verbose: Boolean, addSuffix: Boolean): String

    Permalink
    Definition Classes
    TreeNode

  108. def treeString: String

    Permalink
    Definition Classes
    TreeNode

  109. def validConstraints: Set[Expression]

    Permalink
    Attributes
    protected
    Definition Classes
    QueryPlan

  110. def verboseString: String

    Permalink
    Definition Classes
    QueryPlan → TreeNode

  111. def verboseStringWithSuffix: String

    Permalink
    Definition Classes
    LogicalPlan → TreeNode

  112. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  113. final def wait(arg0: Long, arg1: Int): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  114. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  115. def withNewChildren(newChildren: Seq[LogicalPlan]): LogicalPlan

    Permalink
    Definition Classes
    TreeNode

Inherited from Serializable

Inherited from Serializable

Inherited from RunnableCommand

Inherited from Command

Inherited from LeafNode

Inherited from LogicalPlan

Inherited from Logging

Inherited from QueryPlan[LogicalPlan]

Inherited from TreeNode[LogicalPlan]

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped