input_file_block_start function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the start offset in bytes of the block being read.

This function is not available on Unity Catalog.

In Databricks SQL AND Databricks Runtime 13.3 LTS and above this function is deprecated. Please use _metadata.file_block_start.

Syntax 

input_file_block_start()

Arguments

This function takes no arguments.

Returns

A BIGINT.

If the information is not available -1 is returned.

The function is non-deterministic.

Examples 

> SELECT input_file_block_start();
 -1