ABHISHEK KUMAR GUPTA created SPARK-24082:
--------------------------------------------
Summary: [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
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: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
