I want to view the schema of data which are being stored in kvstore , like what are the keys and their type and also values and their type(as Oracle NoSql is a key-value store). As per my knowledge we can use "show schema " command but it will work only if Avro schema is added in that particular store and second thing is it will give the information of only value names and its type but key name and its type is still a bottleneck. So is there any utility I can use to view the structure of data like we use "describe" command in oracle SQL ?
Metadata information in Oracle NoSql
190 Views Asked by ashish At
1
There are 1 best solutions below
Related Questions in METADATA
- How to solve the issue faced during running command pip install google-colab?
- kid3 - Import Album Art along with other tags from Discogs
- How do I use class in SQLAlchemy. I have being trying to use class but the table is not creating
- How can I get the currently playing media metadata in rust
- Display custom field metadata encoded multidimentional array value in WordPress
- og:image not found when share on linkedin
- Can Powershell independently extract LYRICS audio metadata from multiple flac files to multiple text files?
- In which format should ISRC IDs be included in an Ogg comment field?
- Externally hosted private app in play store error
- Set picklist Value as default value in a field on sales a engagement Runtime Object
- Azure Search blob metadata split multiple values and map to indexer as seperate values
- Hide empty variation cutom fields displayed in WooCommerce
- How to edit the Samsung Trailer Tag "Timestamp"
- I am creating a metadata scrubber web app can anyone help me how can I remove metadata from images
- Meta Box Oxygen Builder Query Custom Post Type based on current date
Related Questions in ORACLE-NOSQL
- Metadata information in Oracle NoSql
- Oracle JSON document select query performance tuning
- Self increment primary key in Oracle NoSQL Database
- Oracle NoSQL Storage Nodes
- CosmosDB query multiple items
- How does implicit casting work in Oracle NoSQL Database?
- Oracle NoSQL Database - Developing with it
- Does Oracle Nosql Cloud Service have provision to set max read units consumption per second?
- Error missing ')' at Oracle NoSQL table creating table
- Error creating a Oracle NoSQL table with ENUM fields
- how to stop debug information when using oracle functions and NoSQLCS
- Does Oracle NoSQL support Open JDK?
- How to see the details of an index in oracle NoSQL?
- Operator BETWEEN and dates in Oracle NoSQL Database, how to do?
- show execution plan of a Oracle NoSQL query
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You are right that 'kv->show schema' will show you the field names (columns) and its types when you have a Avro schema. When you don't register a schema then database have no knowledge of what your value object looks like. In that case client application maintains the schema of the value field (instead of the database).
About the keys, a) keys are always string type b) you can view them from the datashell prompt if you do something like this "kv-> get kv -keyonly -all".
I would also like to mention that in the upcoming R3 release we will be introducing table data model which will give you much closer experience to relational database (in case of table definitions). You can take a look of a webinar we did on this subject: http://bit.ly/1lPazSZ.
Hope that helps, Anuj