[
https://issues.apache.org/jira/browse/SPARK-24082?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ABHISHEK KUMAR GUPTA resolved SPARK-24082.
------------------------------------------
Resolution: Won't Fix
As External table location is set what user mentioned. So closing it.
> [Spark SQL] Tables are not listing under DB
> -------------------------------------------
>
> Key: SPARK-24082
> URL: https://issues.apache.org/jira/browse/SPARK-24082
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.3.0
> Environment: OS: Suse11
> Spark Version: 2.3
> Reporter: ABHISHEK KUMAR GUPTA
> Priority: Minor
>
> Steps:
> # Launch spark-sql --master yarn
> # use one;(* DB name is one )
> # . create table csvTable (time timestamp, name string, isright boolean,
> datetoday date, num binary, height double, score float, decimaler
> decimal(10,0), id tinyint, age int, license bigint, length smallint) using
> CSV options (path "/user/datatmo/customer1.csv");
> # CREATE TABLE Parquettemp USING org.apache.spark.sql.parquet OPTIONS (path
> "/user/sparkhive/warehouse/one.db/test1.parquet/");
> # show tables;
> Tables are listing as below
> one csvtable false
> one parquettemp false
> But when listing the tables under "one.db" in HDFS FIle system, csvTable and
> Parquettemp tables are not listing.
> Used below command
> BLR1000023111:/opt/Antsecure/install/hadoop/namenode/bin # ./hdfs dfs -ls
> /user/sparkhive/warehouse/one.db
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
