| -- |
| -- filesystem |
| -- |
| -- |
| -- ********************************************************************* |
| -- ********************************************************************* |
| -- test filesystem |
| -- |
| -- ********************************************************************* |
| -- ********************************************************************* |
| select * from pg_filesystem; |
| fsysname | fsysconnfn | fsysdisconnfn | fsysopenfn | fsysclosefn | fsysseekfn | fsystellfn | fsysreadfn | fsyswritefn | fsysflushfn | fsysdeletefn | fsyschmodfn | fsysmkdirfn | fsystruncatefn | fsysgetpathinfofn | fsysfreefileinfofn | fsyslibfile | fsysowner | fsystrusted | fsysacl |
| ----------+-------------------+----------------------+--------------------+---------------------+----------------+----------------+----------------+-----------------+----------------+------------------+-----------------+---------------------------+--------------------+-----------------------+------------------------+---------------------+-----------+-------------+--------- |
| hdfs | gpfs_hdfs_connect | gpfs_hdfs_disconnect | gpfs_hdfs_openfile | gpfs_hdfs_closefile | gpfs_hdfs_seek | gpfs_hdfs_tell | gpfs_hdfs_read | gpfs_hdfs_write | gpfs_hdfs_sync | gpfs_hdfs_delete | gpfs_hdfs_chmod | gpfs_hdfs_createdirectory | gpfs_hdfs_truncate | gpfs_hdfs_getpathinfo | gpfs_hdfs_freefileinfo | $libdir/gpfshdfs.so | 10 | f | |
| (1 row) |
| |
| CREATE FILESYSTEM HDFS2 |
| ( |
| gpfs_connect = "gpfs_hdfs_connect", |
| gpfs_disconnect = "gpfs_hdfs_disconnect", |
| gpfs_open = "gpfs_hdfs_openfile", |
| gpfs_close = "gpfs_hdfs_closefile", |
| gpfs_seek = "gpfs_hdfs_seek", |
| gpfs_tell = "gpfs_hdfs_tell", |
| gpfs_read = "gpfs_hdfs_read", |
| gpfs_write = "gpfs_hdfs_write", |
| gpfs_flush = "gpfs_hdfs_sync", |
| gpfs_delete = "gpfs_hdfs_delete", |
| gpfs_chmod = "gpfs_hdfs_chmod", |
| gpfs_mkdir = "gpfs_hdfs_createdirectory", |
| gpfs_truncate = "gpfs_hdfs_truncate", |
| gpfs_getpathinfo = "gpfs_hdfs_getpathinfo", |
| gpfs_freefileinfo = "gpfs_hdfs_freefileinfo", |
| gpfs_libfile = "$libdir/gpfshdfs.so" |
| ); |
| select * from pg_filesystem; |
| fsysname | fsysconnfn | fsysdisconnfn | fsysopenfn | fsysclosefn | fsysseekfn | fsystellfn | fsysreadfn | fsyswritefn | fsysflushfn | fsysdeletefn | fsyschmodfn | fsysmkdirfn | fsystruncatefn | fsysgetpathinfofn | fsysfreefileinfofn | fsyslibfile | fsysowner | fsystrusted | fsysacl |
| ----------+-------------------+----------------------+--------------------+---------------------+----------------+----------------+----------------+-----------------+----------------+------------------+-----------------+---------------------------+--------------------+-----------------------+------------------------+---------------------+-----------+-------------+--------- |
| hdfs | gpfs_hdfs_connect | gpfs_hdfs_disconnect | gpfs_hdfs_openfile | gpfs_hdfs_closefile | gpfs_hdfs_seek | gpfs_hdfs_tell | gpfs_hdfs_read | gpfs_hdfs_write | gpfs_hdfs_sync | gpfs_hdfs_delete | gpfs_hdfs_chmod | gpfs_hdfs_createdirectory | gpfs_hdfs_truncate | gpfs_hdfs_getpathinfo | gpfs_hdfs_freefileinfo | $libdir/gpfshdfs.so | 10 | f | |
| hdfs2 | gpfs_hdfs_connect | gpfs_hdfs_disconnect | gpfs_hdfs_openfile | gpfs_hdfs_closefile | gpfs_hdfs_seek | gpfs_hdfs_tell | gpfs_hdfs_read | gpfs_hdfs_write | gpfs_hdfs_sync | gpfs_hdfs_delete | gpfs_hdfs_chmod | gpfs_hdfs_createdirectory | gpfs_hdfs_truncate | gpfs_hdfs_getpathinfo | gpfs_hdfs_freefileinfo | $libdir/gpfshdfs.so | 10 | f | |
| (2 rows) |
| |
| --err: duplicate name |
| CREATE FILESYSTEM HDFS2 |
| ( |
| gpfs_connect = "gpfs_hdfs_connect", |
| gpfs_disconnect = "gpfs_hdfs_disconnect", |
| gpfs_open = "gpfs_hdfs_openfile", |
| gpfs_close = "gpfs_hdfs_closefile", |
| gpfs_seek = "gpfs_hdfs_seek", |
| gpfs_tell = "gpfs_hdfs_tell", |
| gpfs_read = "gpfs_hdfs_read", |
| gpfs_write = "gpfs_hdfs_write", |
| gpfs_flush = "gpfs_hdfs_sync", |
| gpfs_delete = "gpfs_hdfs_delete", |
| gpfs_chmod = "gpfs_hdfs_chmod", |
| gpfs_mkdir = "gpfs_hdfs_createdirectory", |
| gpfs_truncate = "gpfs_hdfs_truncate", |
| gpfs_getpathinfo = "gpfs_hdfs_getpathinfo", |
| gpfs_freefileinfo = "gpfs_hdfs_freefileinfo", |
| gpfs_libfile = "$libdir/gpfshdfs.so" |
| ); |
| ERROR: duplicate key violates unique constraint "pg_filesystem_fsysname_index" |
| -- err: no gpfs_libfile |
| CREATE FILESYSTEM HDFS3 |
| ( |
| gpfs_connect = "gpfs_hdfs_connect", |
| gpfs_disconnect = "gpfs_hdfs_disconnect", |
| gpfs_open = "gpfs_hdfs_openfile", |
| gpfs_close = "gpfs_hdfs_closefile", |
| gpfs_seek = "gpfs_hdfs_seek", |
| gpfs_tell = "gpfs_hdfs_tell", |
| gpfs_read = "gpfs_hdfs_read", |
| gpfs_write = "gpfs_hdfs_write", |
| gpfs_flush = "gpfs_hdfs_sync", |
| gpfs_delete = "gpfs_hdfs_delete", |
| gpfs_chmod = "gpfs_hdfs_chmod", |
| gpfs_mkdir = "gpfs_hdfs_createdirectory", |
| gpfs_truncate = "gpfs_hdfs_truncate", |
| gpfs_getpathinfo = "gpfs_hdfs_getpathinfo", |
| gpfs_freefileinfo = "gpfs_hdfs_freefileinfo" |
| ); |
| ERROR: filesystem need gpfs_libfile but not specified |
| -- err: dumplicate gpfs_libfile |
| CREATE FILESYSTEM HDFS3 |
| ( |
| gpfs_libfile = "$libdir/gpfshdfs.so", |
| gpfs_libfile = "$libdir/gpfshdfs.so", |
| gpfs_connect = "gpfs_hdfs_connect", |
| gpfs_disconnect = "gpfs_hdfs_disconnect", |
| gpfs_open = "gpfs_hdfs_openfile", |
| gpfs_close = "gpfs_hdfs_closefile", |
| gpfs_seek = "gpfs_hdfs_seek", |
| gpfs_tell = "gpfs_hdfs_tell", |
| gpfs_read = "gpfs_hdfs_read", |
| gpfs_write = "gpfs_hdfs_write", |
| gpfs_flush = "gpfs_hdfs_sync", |
| gpfs_delete = "gpfs_hdfs_delete", |
| gpfs_chmod = "gpfs_hdfs_chmod", |
| gpfs_mkdir = "gpfs_hdfs_createdirectory", |
| gpfs_truncate = "gpfs_hdfs_truncate", |
| gpfs_getpathinfo = "gpfs_hdfs_getpathinfo", |
| gpfs_freefileinfo = "gpfs_hdfs_freefileinfo" |
| ); |
| ERROR: filesystem attribute "gpfs_libfile" duplicated |
| -- err: no gpfs_connect |
| CREATE FILESYSTEM HDFS3 |
| ( |
| gpfs_libfile = "$libdir/gpfshdfs.so", |
| gpfs_disconnect = "gpfs_hdfs_disconnect", |
| gpfs_open = "gpfs_hdfs_openfile", |
| gpfs_close = "gpfs_hdfs_closefile", |
| gpfs_seek = "gpfs_hdfs_seek", |
| gpfs_tell = "gpfs_hdfs_tell", |
| gpfs_read = "gpfs_hdfs_read", |
| gpfs_write = "gpfs_hdfs_write", |
| gpfs_flush = "gpfs_hdfs_sync", |
| gpfs_delete = "gpfs_hdfs_delete", |
| gpfs_chmod = "gpfs_hdfs_chmod", |
| gpfs_mkdir = "gpfs_hdfs_createdirectory", |
| gpfs_truncate = "gpfs_hdfs_truncate", |
| gpfs_getpathinfo = "gpfs_hdfs_getpathinfo", |
| gpfs_freefileinfo = "gpfs_hdfs_freefileinfo" |
| ); |
| ERROR: filesystem need 15 funcs but only get 14 |
| -- err: dumplicate gpfs_connect |
| CREATE FILESYSTEM HDFS3 |
| ( |
| gpfs_libfile = "$libdir/gpfshdfs.so", |
| gpfs_connect = "gpfs_hdfs_connect", |
| gpfs_connect = "gpfs_hdfs_connect", |
| gpfs_disconnect = "gpfs_hdfs_disconnect", |
| gpfs_open = "gpfs_hdfs_openfile", |
| gpfs_close = "gpfs_hdfs_closefile", |
| gpfs_seek = "gpfs_hdfs_seek", |
| gpfs_tell = "gpfs_hdfs_tell", |
| gpfs_read = "gpfs_hdfs_read", |
| gpfs_write = "gpfs_hdfs_write", |
| gpfs_flush = "gpfs_hdfs_sync", |
| gpfs_delete = "gpfs_hdfs_delete", |
| gpfs_chmod = "gpfs_hdfs_chmod", |
| gpfs_mkdir = "gpfs_hdfs_createdirectory", |
| gpfs_truncate = "gpfs_hdfs_truncate", |
| gpfs_getpathinfo = "gpfs_hdfs_getpathinfo", |
| gpfs_freefileinfo = "gpfs_hdfs_freefileinfo" |
| ); |
| ERROR: filesystem function "gpfs_connect" duplicated |
| -- err: not exist |
| DROP FILESYSTEM HDFS3; |
| ERROR: filesystem "hdfs3" does not exist |
| -- drop |
| DROP FILESYSTEM HDFS2; |
| select * from pg_filesystem; |
| fsysname | fsysconnfn | fsysdisconnfn | fsysopenfn | fsysclosefn | fsysseekfn | fsystellfn | fsysreadfn | fsyswritefn | fsysflushfn | fsysdeletefn | fsyschmodfn | fsysmkdirfn | fsystruncatefn | fsysgetpathinfofn | fsysfreefileinfofn | fsyslibfile | fsysowner | fsystrusted | fsysacl |
| ----------+-------------------+----------------------+--------------------+---------------------+----------------+----------------+----------------+-----------------+----------------+------------------+-----------------+---------------------------+--------------------+-----------------------+------------------------+---------------------+-----------+-------------+--------- |
| hdfs | gpfs_hdfs_connect | gpfs_hdfs_disconnect | gpfs_hdfs_openfile | gpfs_hdfs_closefile | gpfs_hdfs_seek | gpfs_hdfs_tell | gpfs_hdfs_read | gpfs_hdfs_write | gpfs_hdfs_sync | gpfs_hdfs_delete | gpfs_hdfs_chmod | gpfs_hdfs_createdirectory | gpfs_hdfs_truncate | gpfs_hdfs_getpathinfo | gpfs_hdfs_freefileinfo | $libdir/gpfshdfs.so | 10 | f | |
| (1 row) |
| |
