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
-1
votes
1 answer

oracle select statement returns “no rows selected”

I created an external table using a .tbl file like this: CREATE TABLE orders_load ( O_ORDERKEY INTEGER , O_CUSTKEY INTEGER , O_ORDERSTATUS CHAR(1) , …
johy
  • 3
  • 1
  • 4
-1
votes
1 answer

SQL Server - Vertica Connection

I need to query a hp vertica database from SQL Server stored procedure. It is a join query and If I use linked server, it is going to fire as 2 separate selects and join it in the SQL Server . Is there any way I can use ODBC to fire the join query…
bithom
  • 186
  • 2
  • 14
-1
votes
1 answer

Oracle invalid character external table

I'am new with oracle.. and i need someone for helping me with my problem.. I was trying to make an External Table in Oracle (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit), and i got an error like this SQL> CREATE TABLE…
Obaja Lumbanraja
  • 3
  • 2
-1
votes
1 answer

Oracle 10G external table error

I have created the following external table on Oracle 10G. connect system/password as SYSDBA create or replace directory ext_tab as 'C:\Suman\External_Tables'; CREATE TABLE emp_ext_3( empno NUMBER(4), first_name CHAR(20), last_name CHAR(20),…
user2032118
  • 455
  • 3
  • 6
  • 16
-3
votes
1 answer

Flat File to SQL server

I want to read data from a TXT/FLAT file and arrange the data using the first column contents as column names and the data after the semi colon as records . SAMPLE…
Jimrosy P Madzokere
  • 23
  • 4
1 2 3
…
25
26