SAP HANA获取csv数据大小 [英] SAP HANA getting csv data size

问题描述

我使用SAP HANA我想知道是否可以使用sql获取磁盘大小的csv数据。
导出后，我的意思是csv数据是文件\index\SCHEMA NAME \CL\TABLE_NAME\data.csv。

I am working with SAP HANA I would like to know if it is possible to get disk size of csv data with sql. The csv data that i mean is the file \index\SCHEMA NAME \CL\TABLE_NAME\data.csv after export.

最佳尊敬的
Houssem

Best Regards Houssem

推荐答案

不，没有办法直接生成。\

Nope, there is no way to generate this directly.\

然而，您可以通过查看M_CS_COLUMNS来查看每个列的估计未压缩大小，从而进行粗略估计。

You could, however, do some rough estimation, by looking at M_CS_COLUMNS to see the estimated uncompressed size for each column.

然后你可以为每一列添加六个字节（双字节编码）*。的记录，以考虑列之间的封闭引号和分隔符。

Then you could add six bytes (double byte encoding) for every column * no. of records to account for the enclosing quotation marks and separators between columns.

这篇关于SAP HANA获取csv数据大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！