Stack Overflow
Stack Overflow

Questions tagged [external-tables]

To be used for External tables. These tables don't necessarily have data in the data warehouse(or database directory).

Hive

An EXTERNAL table points to any HDFS location for its storage, rather than being stored in a folder specified by the configuration property hive.metastore.warehouse.dir(Location of default database for the warehouse). See also official Hive docs on Managed vs External Tables

Oracle

External tables allow Oracle to query data that is stored outside the database in flat files. The ORACLE_LOADER driver can be used to access any data stored in any format that can be loaded by SQL*Loader. No DML can be performed on external tables but they can be used for query, join and sort operations.

381 questions
0
votes
1 answer

HDFS -extra data after last expected column

We have source and target system. trying to import the data from SQL server 2012 to Pivotal Hadoop (PHD 3.0) version using talend tool. Getting error: ERROR: extra data after last expected column (seg0 slice1 datanode.domain.com:40000 pid=15035) …
NEO
  • 389
  • 8
  • 31
0
votes
1 answer

Unable to query external table as a script from SQL Developer

I have an external table defined as: CREATE TABLE EXAM_BDE_ventes ( customerNumber varchar(255), clerkId varchar(255), productId varchar(255), saleDate varchar(255), factoryId varchar(255) ) ORGANIZATION EXTERNAL (TYPE…
Chuck
  • 351
  • 1
  • 6
  • 20
0
votes
1 answer

How to define an HDInsight hive external table based on XMLs in a container

I tried creating a hive external table: CREATE EXTERNAL TABLE TestXML (storexml string) STORED AS TEXTFILE LOCATION 'wasb:///test/'; However when i try executing query like below, its not able to extract the fields: SELECT xpath_string…
madhu m
  • 31
  • 2
0
votes
0 answers

Oracle External Table Columns based on header row or star(*)

I have a text file with around 100 columns terminated by "|". And i need to get few of the columns from this file into by External Table. So the solution i have is either specify all columns under ACCESS PARAMETERS section in the same order as the…
kten
  • 445
  • 4
  • 13
  • 26
0
votes
1 answer

Accessing Created date of a CSV file using an Oracle External table

Situation I have a CSV file called inventory.csv located on an Oracle database server (2008 R2 Enterprise Edition Windows Server). This CSV file is used as an Oracle external table. Every hour, a scheduled task (Windows Task Scheduler) executes a…
chester
  • 297
  • 2
  • 13
0
votes
0 answers

Write same external table query to be used in different databases inside one instance of Hive

I need to create an external table command for Hive. The command requires you to specify the location also. Issue is that the same command will be used in multiple databases inside one Hive instance. Is there a way to include Hive database name…
help
  • 120
  • 1
  • 1
  • 10
0
votes
1 answer

From SQLoader to External Tables [Oracle]

At the moment I have some flat files, that are loaded in DB with SQLoader, but I would like to replace SQLoader scripts with external tables, but I am having problems with "translating" SQLoader to external tables. So, for example I have a flat…
Uldis Bajārs
  • 37
  • 4
0
votes
1 answer

PostgreSQL: foreign table and discarded records

where PostgreSQL stores records which were discarded from the foreign table during select? I have following table: CREATE FOREIGN TABLE ext.alternatenamesext ( altid BIGINT, geoid BIGINT, isolanguage VARCHAR(7), alternatename TEXT, …
Green Root
  • 644
  • 2
  • 10
  • 28
0
votes
1 answer

external tables in Hive

I added a CSV file in HDFS using R script. I update this CSV with new CSV/append data to it Created table using hue in Hive over this CSV. Altered it to be an external table. Now, if when data is changed in the hdfs location, would data be…
systemdebt
  • 4,589
  • 10
  • 55
  • 116
0
votes
1 answer

error while trying to select from external table

I am getting the below error while trying to select * from ext_poc ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-00554: error encountered while parsing access parameters KUP-01005: syntax error:…
Aldrin D'souza
  • 3
  • 4
0
votes
3 answers

insert data to external table from an external table

While inserting data to an external table-2 from an external table-1 the data of external table-2 gets stored in /user/hive/warehouse/db-name/table-name/,but as an external table it should not store data into warehouse directory right? Should we…
Barath
  • 107
  • 2
  • 14
0
votes
2 answers

Insert comma separated data in external table in hive

create external table transaction_usa_canada ( tran_id int, acct_id int, tran_date string, amount double, description string, branch_code string, product string, tran_state string, tran_city string, speendby string, tran_zip int, source_table…
user2998990
  • 970
  • 5
  • 18
  • 36
0
votes
3 answers

Insert data of 2 Hive external tables in new External table with additional column

I have 2 external hive tables as follows. I have populated data in them from oracle using sqoop. create external table transaction_usa ( tran_id int, acct_id int, tran_date string, amount double, description string, branch_code string, tran_state…
user2998990
  • 970
  • 5
  • 18
  • 36
0
votes
2 answers

Merge 2 external hive tables into single new table

I am new to hive. I have created 2 external hive tables and also imported data from oracle using sqoop. Also I have created a new external table which will have data of both External table 1 and External table 2 as follows create external table…
user2998990
  • 970
  • 5
  • 18
  • 36
0
votes
2 answers

How to import third line only in oracle using sql loader or external table

I have this data to load in to oracle i use external table concept to load the data . any idea how to load only the third line from the source ? This is the data in txt externally located …
arya
  • 436
  • 1
  • 5
  • 18
1 2 3
…
25 26