[INCOMPATIBLE_COLUMN_TYPE] UNION can only be performed on tables with compatible column types. The first column of the second table is "STRING" type which is not compatible with "STRUCT
Traceback (most recent call last):
File "/opt/acc-bpt/release_2026_01/jinja/build_static_plots.py", line 85, in _create_static_html_content
output_html_file_path = driver.build(abs_plot_dest_file_html)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/acc_bpt/shared/BptV2.py", line 315, in build
raise ex
File "/opt/acc-bpt/release_2026_01/acc_bpt/shared/BptV2.py", line 284, in build
rawdata = self.bptStatic.fetch(vars, times)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/acc_bpt/linac4/RF/PER_RING/shared/script_ln4_rfq.py", line 66, in fetch
res = self.nxcals.fetch_vars_list(time_ranges[0], time_ranges[1], vars_list=var_defs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/acc_bpt/shared/utils_nxcals.py", line 385, in fetch_vars_list
return self._fetch_vars_of_same_type(ts1, ts2, vars_like=None, vars_list=vars_list, acc_name=acc_name,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/acc_bpt/shared/utils_nxcals.py", line 436, in _fetch_vars_of_same_type
sdfs = self._get_vars_raw(nxcals_query, vars_like, vars_list, system)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/acc_bpt/shared/utils_nxcals.py", line 452, in _get_vars_raw
return nxcals_query._get_varslist_raw(vars_list, system)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/acc_bpt/shared/utils_nxcals_queries.py", line 185, in _get_varslist_raw
.buildDataset() \
^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/venv/lib/python3.11/site-packages/nxcals/api/extraction/data/common.py", line 111, in buildDataset
return self.build()
^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/venv/lib/python3.11/site-packages/nxcals/api/extraction/data/common.py", line 114, in build
return self._builder._build()
^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/venv/lib/python3.11/site-packages/nxcals/api/extraction/data/builders.py", line 33, in _build
df = self._get_java_builder().build()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/venv/lib/python3.11/site-packages/py4j/java_gateway.py", line 1322, in __call__
return_value = get_return_value(
^^^^^^^^^^^^^^^^^
File "/opt/acc-bpt/release_2026_01/venv/lib/python3.11/site-packages/pyspark/errors/exceptions/captured.py", line 185, in deco
raise converted from None
pyspark.errors.exceptions.captured.AnalysisException: [INCOMPATIBLE_COLUMN_TYPE] UNION can only be performed on tables with compatible column types. The first column of the second table is "STRING" type which is not compatible with "STRUCT, dimensions: ARRAY>" at the same column of the first table..;
'Union false, false
:- Project [means#1623 AS nxcals_value#1630, __sys_nxcals_entity_id__#1625L AS nxcals_entity_id#1631L, __record_timestamp__#1624L AS nxcals_timestamp#1632L, means AS nxcals_field_name#1633]
: +- Filter (((((entityKey#1621 >= 0__9155517__7451711236854775807) AND (entityKey#1621 < 0__9155517__7451797576854784808)) OR ((entityKey#1621 >= 1__9155517__7451711236854775807) AND (entityKey#1621 < 1__9155517__7451797576854784808))) OR (((entityKey#1621 >= 2__9155517__7451711236854775807) AND (entityKey#1621 < 2__9155517__7451797576854784808)) OR ((entityKey#1621 >= 3__9155517__7451711236854775807) AND (entityKey#1621 < 3__9155517__7451797576854784808)))) OR ((((entityKey#1621 >= 0__9157484__7451711236854775807) AND (entityKey#1621 < 0__9157484__7451797576854784808)) OR ((entityKey#1621 >= 1__9157484__7451711236854775807) AND (entityKey#1621 < 1__9157484__7451797576854784808))) OR (((entityKey#1621 >= 2__9157484__7451711236854775807) AND (entityKey#1621 < 2__9157484__7451797576854784808)) OR ((entityKey#1621 >= 3__9157484__7451711236854775807) AND (entityKey#1621 < 3__9157484__7451797576854784808)))))
: +- Project [cast(entityKey#1609 as string) AS entityKey#1621, cast(cast(means#1610 as struct,dimensions:array>) as struct,dimensions:array>) AS means#1623, cast(__record_timestamp__#1611L as bigint) AS __record_timestamp__#1624L, cast(__sys_nxcals_entity_id__#1612L as bigint) AS __sys_nxcals_entity_id__#1625L]
: +- Relation [entityKey#1609,means#1610,__record_timestamp__#1611L,__sys_nxcals_entity_id__#1612L] HBaseRelation(Map(catalog -> {"table": {"namespace": "nxcals_pro", "name":"2__48221__536503"},"rowkey":"id","columns":{"entityKey":{"cf":"rowkey","col":"id","type":"string"},"means":{"cf":"data","col":"means","avro":"2__48221__536503__nxcals_value"},"__record_timestamp__":{"cf":"data","col":"__record_timestamp__","type":"long"},"__sys_nxcals_entity_id__":{"cf":"data","col":"__sys_nxcals_entity_id__","type":"long"}}}, 2__48221__536503__nxcals_value -> [{"type":"record","name":"double_multi_array","namespace":"cern.nxcals","fields":[{"name":"elements","type":[{"type":"array","items":"double"},"null"]},{"name":"dimensions","type":[{"type":"array","items":"int"},"null"]}]},"null"]),None)
+- Project [lsaCycleName#1655 AS nxcals_value#1662, __sys_nxcals_entity_id__#1657L AS nxcals_entity_id#1663L, __record_timestamp__#1656L AS nxcals_timestamp#1664L, lsaCycleName AS nxcals_field_name#1665]
+- Filter ((((entityKey#1654 >= 0__1614174__7451711236854775807) AND (entityKey#1654 < 0__1614174__7451797576854784808)) OR ((entityKey#1654 >= 1__1614174__7451711236854775807) AND (entityKey#1654 < 1__1614174__7451797576854784808))) OR (((entityKey#1654 >= 2__1614174__7451711236854775807) AND (entityKey#1654 < 2__1614174__7451797576854784808)) OR ((entityKey#1654 >= 3__1614174__7451711236854775807) AND (entityKey#1654 < 3__1614174__7451797576854784808))))
+- Project [cast(entityKey#1642 as string) AS entityKey#1654, cast(lsaCycleName#1643 as string) AS lsaCycleName#1655, cast(__record_timestamp__#1644L as bigint) AS __record_timestamp__#1656L, cast(__sys_nxcals_entity_id__#1645L as bigint) AS __sys_nxcals_entity_id__#1657L]
+- Relation [entityKey#1642,lsaCycleName#1643,__record_timestamp__#1644L,__sys_nxcals_entity_id__#1645L] HBaseRelation(Map(catalog -> {"table": {"namespace": "nxcals_pro", "name":"2__15291__647497"},"rowkey":"id","columns":{"entityKey":{"cf":"rowkey","col":"id","type":"string"},"lsaCycleName":{"cf":"data","col":"lsaCycleName","type":"string"},"__record_timestamp__":{"cf":"data","col":"__record_timestamp__","type":"long"},"__sys_nxcals_entity_id__":{"cf":"data","col":"__sys_nxcals_entity_id__","type":"long"}}}),None)
Generated 2026-02-21 09:03:02.086503+01:00