Versions Compared

Old Version 3

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 4

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Version published after converting to the new editor

Applies to: Image Modified Kyvos Enterprise   Image Modified Kyvos Cloud   Image Modified Kyvos Azure Marketplace  

Image Modified Kyvos Single Node Standard Installation  Image Modified Kyvos Single Node Installation  Image Modified Kyvos Free

When you are registering datasets, you can specify how data is formatted, which data is included, how it is sorted, and more.

Info
titleInfo

Kyvos does not support some special characters/values. Either remove them from the source data or contact the Kyvos Support team for assistance.
Example of unsupported values: [New line character 'n', HTML tags, KYVOS_NULL_VALUE, !==!, ~, !__!, !@!, !@@!]

Formatting data

Kyvos allows you to change the data type for columns while registering datasets. The supported Data Types are char, date, and number.

...

Info
titleInfo
  • If the raw data contains decimal values, Kyvos detects it as a  Double, by default. If you do not want any precision loss post cube build-in querying, then set the  Data Type  of the respective field as  Decimal  and set the correct  precisions  and  scale  to avoid any data inaccuracy and precision loss. Cube build size may increase if the data type is  Decimal.
  • From the Kyvos 2023.1 release onwards, the Decimal data type is applicable only when registering a dataset using a BigQuery connection. The Decimal data type will only be applicable to new Register datasets, while the previous data types (long, float, and double) will be used for existing register files.

Working with Dates

Generally, date columns store dates as strings. Kyvos then reads the date using the default format YYYY/MM/DD.  If the date format of the source data doesn't match the default format, then Kyvos will throw an error while validating the registered dataset. To improve performance and avoid errors, you should specify the format string for the date.

...