Reading data from Spaces

[apeksha-r-naik]

Hello Team,
Currently we are reading the data from the specific spaces like below

options = tbapi.SelectionOptions()
options.space = "20230602"
cursor = tb_connection.executeQuery(qqlQuery, options)   

But in the result instead of specified space some different space data is getting loaded.

when we run the below query:
select count{} () as TIMEBASE_COUNT, symbol, trade_type, run_date, venue from

where symbol=='EURUSD'

We get the below output:

@alex-karpovich It is giving us the result from different space using python launguage.

[ankitsoin]

Hi @alex-karpovich ,

Using timebase client 6.0.4
Can you please let us know, below is the correct way to read data from spaces of the stream using python?

options = tbapi.SelectionOptions()
options.space = "20230602"
cursor = tb_connection.executeQuery(qqlQuery, options)

We found out that while querying data for space "20230602" timebase is scanning whole stream instead of that particular space.
Or we need to add something else as well for reading from spaces using python?

[alex-karpovich]

Greetings, @ankitsoin
Sorry for long delay, I would recommend to switch to the latest version: 6.1.20 for the TimeBase Server and Client
API changed a bit ti support several spaces in selection (JAVA):

SelectionOptions so = new SelectionOptions();
so.withSpace("20230602");

[apeksha-r-naik]

Thanks @alex-karpovich for you quick response!

We tested the functionality again [reading the data from the spaces using (PYTHON) ] this morning by upgrading TB client version to the latest one i.e. 6.0.5, we are still facing the issue,

Instead of specific space counts (e.g "20230602") it is giving the counts from the whole stream.

Could you please let us know by when we can expect this fix.

[alex-karpovich]

Please use TimeBase Server 6.1.21 https://github.com/finos/TimeBase-CE/releases/tag/6.1.21
And use Python API 6.0.5

[ankitsoin]

Hi @alex-karpovich,
We have upgraded TB server as well as python client to the above latest version.

But still we are unable to fetch records from particular spaces. We are getting records from all whole stream.

May I know is this code we should use?

options = tbapi.SelectionOptions()
options.space = "20230602"
cursor = tb_connection.executeQuery(qqlQuery, options)

[Romkisel]

Hi, @ankitsoin
Please, try the following api: options.withSpaces(['Space1', 'Space2', ...]). For example:

            options = tbapi.SelectionOptions()
            options.withSpaces(['20230602'])
            cursor = tb_connection.executeQuery(qqlQuery, options)

[apeksha-r-naik]

Thank you @Romkisel @alex-karpovich, we are successfully able to read the data from particular spaces using python script.