[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#603 AS nxcals_value#610, __sys_nxcals_entity_id__#605L AS nxcals_entity_id#611L, __record_timestamp__#604L AS nxcals_timestamp#612L, means AS nxcals_field_name#613]
: +- Filter (((((entityKey#601 >= 0__9155517__7447286836854775807) AND (entityKey#601 < 0__9155517__7447373176854781808)) OR ((entityKey#601 >= 1__9155517__7447286836854775807) AND (entityKey#601 < 1__9155517__7447373176854781808))) OR (((entityKey#601 >= 2__9155517__7447286836854775807) AND (entityKey#601 < 2__9155517__7447373176854781808)) OR ((entityKey#601 >= 3__9155517__7447286836854775807) AND (entityKey#601 < 3__9155517__7447373176854781808)))) OR ((((entityKey#601 >= 0__9157484__7447286836854775807) AND (entityKey#601 < 0__9157484__7447373176854781808)) OR ((entityKey#601 >= 1__9157484__7447286836854775807) AND (entityKey#601 < 1__9157484__7447373176854781808))) OR (((entityKey#601 >= 2__9157484__7447286836854775807) AND (entityKey#601 < 2__9157484__7447373176854781808)) OR ((entityKey#601 >= 3__9157484__7447286836854775807) AND (entityKey#601 < 3__9157484__7447373176854781808)))))
: +- Project [cast(entityKey#589 as string) AS entityKey#601, cast(cast(means#590 as struct,dimensions:array>) as struct,dimensions:array>) AS means#603, cast(__record_timestamp__#591L as bigint) AS __record_timestamp__#604L, cast(__sys_nxcals_entity_id__#592L as bigint) AS __sys_nxcals_entity_id__#605L]
: +- Relation [entityKey#589,means#590,__record_timestamp__#591L,__sys_nxcals_entity_id__#592L] 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#635 AS nxcals_value#642, __sys_nxcals_entity_id__#637L AS nxcals_entity_id#643L, __record_timestamp__#636L AS nxcals_timestamp#644L, lsaCycleName AS nxcals_field_name#645]
+- Filter ((((entityKey#634 >= 0__1614174__7447286836854775807) AND (entityKey#634 < 0__1614174__7447373176854781808)) OR ((entityKey#634 >= 1__1614174__7447286836854775807) AND (entityKey#634 < 1__1614174__7447373176854781808))) OR (((entityKey#634 >= 2__1614174__7447286836854775807) AND (entityKey#634 < 2__1614174__7447373176854781808)) OR ((entityKey#634 >= 3__1614174__7447286836854775807) AND (entityKey#634 < 3__1614174__7447373176854781808))))
+- Project [cast(entityKey#622 as string) AS entityKey#634, cast(lsaCycleName#623 as string) AS lsaCycleName#635, cast(__record_timestamp__#624L as bigint) AS __record_timestamp__#636L, cast(__sys_nxcals_entity_id__#625L as bigint) AS __sys_nxcals_entity_id__#637L]
+- Relation [entityKey#622,lsaCycleName#623,__record_timestamp__#624L,__sys_nxcals_entity_id__#625L] 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-04-13 15:01:49.466878+02:00