Workspaces API

Create external table from CSV file on hadoop

POST /api/workspaces/:workspace_id/external_tables

Parameters

Name Description
hdfs_entry_id Id of the source HDFS file or directory
path_type Type of source for external table ['file' (default), 'pattern' or 'directory']
file_pattern Regular expression specifying file names to include (only when path_type is 'pattern')
column_names[] Array of column names
types[] Array of column types
delimiter Delimiter (i.e. , or ;)
table_name Name of the table to be created
workspace_id Id of the workspace to create the table in

Request

Headers

Host: example.org
Content-Type: application/x-www-form-urlencoded
Cookie: _session_id=ZDIxTWtXNE9iZUZrRTdXN0xhMzcrWng1Y25NTm9UanplRlJQUVZwZ0RBUzBtZkYyZFR6Nlk0K3RyMW8xSXk5engvQjBLelI0Yk1IMHYyZU1sYkRjeWpBVVBKVFFnczR5N3huK3pFSUZwZHk4UkVuN2dBSUhvRTVNc0hpcm1yTUJER0Ixcmw0Y0VIU29YNDhqR2lCcXpXRzRwVnNhdTJYZEQ0SWJCTHo3cHdQQWltM09MZkhVc0JoQnhCZDBBTjNOYkNHdXhHSi8rYnpjQUFvM0xQejQ1bllBUUtMbzR3aUo1SENOUitKcldlbnFpK1ZRY1dIQ2dDNUlra05jZUhMdUV1UU5hZmVmaEJVNUpqdDBlWkw0eFZHanpmejBJTXE4eWZOWmd1Y1N4K3BMazl6RjhhUnJzd0xMTTZON1NSMEJsZU1GUUdtRWsraXoydElWNkR4Y3p3SStCOTMwZ0h4cE13bHp3WVY5UlJUZFlPaDZrLzM3MGR6VE1nRUNGRXFtckFPY2szT09IeFJUd2w4MjRmRURpMThHQlFFeHhJcS9IU3Z2UXBPZTQ2ST0tLXpkNnRndDZrV2Q0bFByRjlpTm80VEE9PQ%3D%3D--2f1f9eeab7cb7697cb876face064f08ee299a181

Route

POST /api/workspaces/1000008/external_tables

Body

Response

Headers

X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff
Content-Type: application/json; charset=utf-8
ETag: W/"99914b932bd37a50b983c5e7c90ae93b"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=c3VSMWhucSsvUGFTY0JqV0NXeVBPWlRTbXoyQTBaaWh0bmExTjZhTkxVTWN0aHZiNkQzdTliMGpKMTBRcnAvaktEVkdDWVNYYzRnbXQvbWZkdjI2cWNpQ2JtZ1JmOGYybTNWMjdmY3ZrbUhRbmNHbHJQQjJMMjIrc3Y3VXo1OVBNRkxTcGR3K3hwR3BDMWplY3FlUnpMVm4yaU1hRVBvcXB2RDV6UW5PbUxVK0FFcW5IWGV3ZVNCSXJGMjc1QlBZMEJScDVGWCtoVXprM3RlazFTb3pPZDNYbTh6WitYWEljejVxMDgwVG9pL2FXMHZvWXFXbXlRR29FM0hKNFJhVzNDRVM1SS9JaWNkenlqMFRTeFBpS0Fabk43TW5TQXU5bm9yMG0rM3lIemcrVkNjZVZtblY3clFHMitmY0VrdDJtRUVnK0hiZVpROEY4bXJJSHB2Vlg3ME9TeXFaOFVXM29XekhFdG1rWUZEK0hxQVRRMVdtNFlaaWV4R2N5dWhTVkRjT1dWV1RYL1g0ejJpeUFUVktYYzByYnhIdVppbXVFWGliOU9Rbzc2WjkxU1FQUzhLb3NGTkF1eXJlMUFCNC0tN2VjYmJtYlNXSjZuM25nRkxDaFk3Zz09--0f66c123ca6343bbf219cc062c6b10a99ae7f38c; path=/; HttpOnly
X-Request-Id: 7cb8e490-53be-4de2-8887-2f941d91497f
X-Runtime: 0.205379
Content-Length: 2

Status

200 OK

Body