0

I ran the below create script and it created the table:-

Create writable external table FLTR (like dbname.FLTR)
LOCATION ('gpfdist://172.90.38.190:8081/fltr.out')
FORMAT 'CSV' (DELIMITER ',' NULL '') 
DISTRIBUTED BY (fltr_key);

But when I tried inserting into the file like insert into fltr.out select * from dbname.fltr I got the below error, cannot find server connection.

Please help me out

Mehrdad
  • 708
  • 1
  • 17
  • 38
user3138134
  • 1
  • 1
  • Is there actually a server running at 172.90.38.190 ? If so, this questions is perhaps better suited for your network admin, or perhaps superUser. – KarlP Dec 27 '13 at 01:12

1 Answers1

0

I think your gpfdist is probably not running try:

gpfdist -p 8081 -l ~/gpfdist.log -d ~/ &

on 172.90.38.190.

This will start gpfidist using your home directory as the data directory.

When I do that my inserts work and create a file ~/fltr.out

Wes Reing
  • 108
  • 4