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
0 answers

External table creation in SP

What i am trying is to read data from csv and insert it into external table after insert i have to update my orginal table with the values of extrernal table because couldn't update table using sqlloader for that i have followed as per the link…
jackyesind
  • 3,343
  • 14
  • 47
  • 74
0
votes
1 answer

External table creation in oracle using csv from ftp location

I am trying to load the csv file data into external_tables for this i have tried create table ext_table_csv ( i Number, n Varchar2(20), m Varchar2(20) ) organization external ( type …
jackyesind
  • 3,343
  • 14
  • 47
  • 74
0
votes
2 answers

Greenplum - external tables

I have a set of tab delimited files located on a server location and I have created a meta data table and an external table with the same layout as the metadata table. I wanted to know when I run the external table script in PgAdmin 3 is it…
jason
  • 1
  • 1
  • 2
0
votes
1 answer

Oracle external table date field - works in one DB and not in another

Here's a crazy one: the same external table definition works fine in one database, but fails in another. Not schema - database. Two databases, both on the same OS, different servers. In addition, it's failing on the 2nd date field, though both are…
leanne
  • 7,940
  • 48
  • 77
0
votes
1 answer

Oracle SQL save file name from LOCATION as a column in external table

I have several input files being read into an external table in Oracle. I want to run some queries across the content from all the files, however, there are some queries where I would like to filter the data based on the input file it came from. Is…
user2055964
  • 1
  • 1
  • 1
0
votes
3 answers

Why External table concept has been established in Oracle?

SQL*Loader: Oracle uses this functionality, through the ORACLE_LOADER access driver to move data from a flat file into the database; Data Pump: It uses a Data Pump access driver to move data out of the database into a file in an proprietary Oracle…
CodeLover
  • 1,054
  • 6
  • 24
  • 40
0
votes
1 answer

How can I use Oracle Preprocessor for External Tables to consume this type of format?

Suppose I have a custom file format, which can be analogous to N tables. Let's pick 3. I could transform the file, writing a custom load wrapper to fill 3 database tables. But suppose for space and resource constraints, I can't store all of this in…
maxwellb
  • 13,366
  • 2
  • 25
  • 35
0
votes
1 answer

Read Excel from DB2

I have to import some Excel data on a regular basis. Checking the DB2 documentation one can directly access OLE DB datasources via an external function. However I'm unable to set it up properly. I got the Microsoft Access Database Enginge 2010 plus…
Udo Held
  • 12,314
  • 11
  • 67
  • 93
0
votes
1 answer

How to read a file present in application server using External tables

How to read a file present in application server using external tables. I can't place the file in DB server as we are restricted from DB server.
kanna
  • 101
  • 7
-1
votes
1 answer

Oracle : load data from client machine

I'm looking for a solution to read the data from client machine and load into oracle database , by using sql loader/external table first we need to copy the file into oracle server directory to load but looking for any alternative by using any…
kumar
  • 3
  • 2
-1
votes
1 answer

Oracle External Table RECORDS DELIMITED BY '",\n"' not working

I am trying to read large CSV files with lots of Newline characters in them. this is how the data looks like in the CSV file. "LastValueInRow", "FirstValueInNextRow", I would like to use " + , + NEWLINE + " as records delimiter…
Mario Douh
  • 49
  • 6
-1
votes
1 answer

How to use external table feature to load .dat file

I wish to import .dat file using oracle external table feature. File Format is as follows and file name test_210228053753.dat 00000000000005000.00517081233434 28/02/2021 781750202Claim Benefit Payout …
lobh
  • 33
  • 7
-1
votes
1 answer

Creating External Tables in Snowflake

Is it possible to create external table in Snowflake referring to on premise Oracle database?
Veeru
  • 3
  • 1
-1
votes
1 answer

Polybase : Querying the external table giving error but offending value shows nothing

I've compressed the text file in gzip format using powershell and uploaded into Azure blob . When i query the external table i'm getting the following error but offending value is nothing . Can any one tell me what is the issue and how can i find…
praveen pasumarthi
  • 3
  • 2
-1
votes
1 answer

Copying data from External table to database

I'm having a data in a external table. Now I'm copying the data from external table to a newly created table in a database. What kind of table will be the table in the database? Is it a managed table or external table? I need your help to understand…
Madan Mohan
  • 1
  • 1
1 2 3
…
25
26