[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#1253 AS nxcals_value#1260, __sys_nxcals_entity_id__#1255L AS nxcals_entity_id#1261L, __record_timestamp__#1254L AS nxcals_timestamp#1262L, means AS nxcals_field_name#1263]
: +- Filter (((((entityKey#1251 >= 0__9155517__7449680836854775807) AND (entityKey#1251 < 0__9155517__7449767176854782808)) OR ((entityKey#1251 >= 1__9155517__7449680836854775807) AND (entityKey#1251 < 1__9155517__7449767176854782808))) OR (((entityKey#1251 >= 2__9155517__7449680836854775807) AND (entityKey#1251 < 2__9155517__7449767176854782808)) OR ((entityKey#1251 >= 3__9155517__7449680836854775807) AND (entityKey#1251 < 3__9155517__7449767176854782808)))) OR ((((entityKey#1251 >= 0__9157484__7449680836854775807) AND (entityKey#1251 < 0__9157484__7449767176854782808)) OR ((entityKey#1251 >= 1__9157484__7449680836854775807) AND (entityKey#1251 < 1__9157484__7449767176854782808))) OR (((entityKey#1251 >= 2__9157484__7449680836854775807) AND (entityKey#1251 < 2__9157484__7449767176854782808)) OR ((entityKey#1251 >= 3__9157484__7449680836854775807) AND (entityKey#1251 < 3__9157484__7449767176854782808)))))
: +- Project [cast(entityKey#1239 as string) AS entityKey#1251, cast(cast(means#1240 as struct,dimensions:array>) as struct,dimensions:array>) AS means#1253, cast(__record_timestamp__#1241L as bigint) AS __record_timestamp__#1254L, cast(__sys_nxcals_entity_id__#1242L as bigint) AS __sys_nxcals_entity_id__#1255L]
: +- Relation [entityKey#1239,means#1240,__record_timestamp__#1241L,__sys_nxcals_entity_id__#1242L] 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#1285 AS nxcals_value#1292, __sys_nxcals_entity_id__#1287L AS nxcals_entity_id#1293L, __record_timestamp__#1286L AS nxcals_timestamp#1294L, lsaCycleName AS nxcals_field_name#1295]
+- Filter ((((entityKey#1284 >= 0__1614174__7449680836854775807) AND (entityKey#1284 < 0__1614174__7449767176854782808)) OR ((entityKey#1284 >= 1__1614174__7449680836854775807) AND (entityKey#1284 < 1__1614174__7449767176854782808))) OR (((entityKey#1284 >= 2__1614174__7449680836854775807) AND (entityKey#1284 < 2__1614174__7449767176854782808)) OR ((entityKey#1284 >= 3__1614174__7449680836854775807) AND (entityKey#1284 < 3__1614174__7449767176854782808))))
+- Project [cast(entityKey#1272 as string) AS entityKey#1284, cast(lsaCycleName#1273 as string) AS lsaCycleName#1285, cast(__record_timestamp__#1274L as bigint) AS __record_timestamp__#1286L, cast(__sys_nxcals_entity_id__#1275L as bigint) AS __sys_nxcals_entity_id__#1287L]
+- Relation [entityKey#1272,lsaCycleName#1273,__record_timestamp__#1274L,__sys_nxcals_entity_id__#1275L] 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-03-16 21:01:38.960435+01:00