Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Able to create external table to query csv files as a table...

Gbenga AjakayeSep 12 2016 — edited Sep 12 2016

I think it would be nice to be able to create a external that points to a .csv that I can then query like a regular table.

Each csv columns will represent a table column.

Comments

Darren Moffat-Oracle
Answer

Solaris 11.4 has resumable send stream enabled by default.  If you pass '-s nocheck' to the 11.4 'zfs send' then it will remove the feature flag and metadata for resumable send and 11.3 should be able to see it.

From the zfs(8) man page on 11.4:

       -s check

           Specifies that the output stream will use a send stream  format
           that  uses per-record checksums. This format is the system-wide
           default. When an interrupted transfer is  resumed  by  using  a
           receive  checkpoint  (see zfs send --C), the use of the 'check'
           format before the outage enables the resumed transfer  to  pre-
           serve  and  reuse the portions of the interrupted snapshot that
           were already successfully received.

       -s nocheck

           Specifies that the output stream will use a legacy send  stream
           format  without  per-record  checksums. This format is suitable
           for transmission to older systems that do not support  the  new
           format.

$ zfs send SomePool1/SomeThing@123 | zstreamdump -v | grep 'features ='

    features = a4

Note that a4 is the flags that were in the send stream:

$ zfs send -s nocheck SomePool1/SomeThing@123 | zstreamdump -v | grep 'features ='

    features = 24

--

Darren J Moffat

Senior Software Architect - Oracle Solaris Engineering

Marked as Answer by User277246 · Sep 27 2020
1 person found this helpful
User277246

That was it.


Thanks

1 - 2

Post Details

Added on Sep 12 2016
#active, #database-ideas, #database-ideas-ideas
12 comments
257 views