Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

NOTE: To work with formats that are proprietary to a desktop application, such as Microsoft Excel, you do not need the supporting application installed on your desktop.

Filenames:

Info

NOTE: Filenames that include special characters can cause problems during import or when publishing to a file-based datastore. Do not use the slash (/) character in your filenames.

Native Input File Formats:

...

  • Excel (XLS/XLSX), upload only

    Tip

    Tip: You may import multiple worksheets from a single workbook at one time. See Import Excel Data.


  • CSV
  • JSON, including nested

    Info

    NOTE:

    D s product
    requires that JSON files be submitted with one valid JSON object per line. Consistently malformed JSON objects or objects that overlap linebreaks might cause import to fail. See Initial Parsing Steps.


  • Plain Text
  • LOG
  • TSV
  •  

    XML

    Infotip

    NOTETip: XML files can be ingested as unstructured text. XML support is not enabled by default. For more information, please contact d-s-proserv.

 



  • Avro

Info

NOTE:

D s product
supports Hive connectivity, which can be used to read data for Hadoop file formats that are not listed here, such as Parquet. For more information, please view the documentation for your Hive version.

For more information on data is handled initially, see Initial Parsing Steps. 


Native Output File Formats:

D s product
 can write to these file formats:

  • CSV
  • JSON

 


  • Tableau (TDE)
  • Avro

    Info

    NOTE: The Photon and Spark running environments apply Snappy compression to this format.


  • Parquet

    Info

    NOTE: The Photon and Spark running environments apply Snappy compression to this format.

 

 




Compression Algorithms:

 

 



Info

NOTE: Importing a compressed file with a high compression ratio can overload the available memory for the application. In such cases, you can uncompress the file before uploading.

Or, if that fails, you should contact your administrator about increasing the Java Heap Size memory.

...

Read Native File Formats:

...


GZIPBZIPSnappy
CSV SupportedSupportedSupported
JSONSupportedSupportedSupported
Avro  

Supported
Hive  

Supported

Write Native File Formats:


 GZIPBZIPSnappy
CSVSupportedSupportedSupported
JSONSupportedSupportedSupported
Avro  

Supported; always on
Hive  

Supported; always on

 

 

...