[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#1000 AS nxcals_value#1007, __sys_nxcals_entity_id__#1002L AS nxcals_entity_id#1008L, __record_timestamp__#1001L AS nxcals_timestamp#1009L, means AS nxcals_field_name#1010]
: +- Filter (((((entityKey#998 >= 0__9155517__7437210436854775807) AND (entityKey#998 < 0__9155517__7437296776854785808)) OR ((entityKey#998 >= 1__9155517__7437210436854775807) AND (entityKey#998 < 1__9155517__7437296776854785808))) OR (((entityKey#998 >= 2__9155517__7437210436854775807) AND (entityKey#998 < 2__9155517__7437296776854785808)) OR ((entityKey#998 >= 3__9155517__7437210436854775807) AND (entityKey#998 < 3__9155517__7437296776854785808)))) OR ((((entityKey#998 >= 0__9157484__7437210436854775807) AND (entityKey#998 < 0__9157484__7437296776854785808)) OR ((entityKey#998 >= 1__9157484__7437210436854775807) AND (entityKey#998 < 1__9157484__7437296776854785808))) OR (((entityKey#998 >= 2__9157484__7437210436854775807) AND (entityKey#998 < 2__9157484__7437296776854785808)) OR ((entityKey#998 >= 3__9157484__7437210436854775807) AND (entityKey#998 < 3__9157484__7437296776854785808)))))
: +- Project [cast(entityKey#986 as string) AS entityKey#998, cast(cast(means#987 as struct,dimensions:array>) as struct,dimensions:array>) AS means#1000, cast(__record_timestamp__#988L as bigint) AS __record_timestamp__#1001L, cast(__sys_nxcals_entity_id__#989L as bigint) AS __sys_nxcals_entity_id__#1002L]
: +- Relation [entityKey#986,means#987,__record_timestamp__#988L,__sys_nxcals_entity_id__#989L] 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#1032 AS nxcals_value#1039, __sys_nxcals_entity_id__#1034L AS nxcals_entity_id#1040L, __record_timestamp__#1033L AS nxcals_timestamp#1041L, lsaCycleName AS nxcals_field_name#1042]
+- Filter ((((entityKey#1031 >= 0__1614174__7437210436854775807) AND (entityKey#1031 < 0__1614174__7437296776854785808)) OR ((entityKey#1031 >= 1__1614174__7437210436854775807) AND (entityKey#1031 < 1__1614174__7437296776854785808))) OR (((entityKey#1031 >= 2__1614174__7437210436854775807) AND (entityKey#1031 < 2__1614174__7437296776854785808)) OR ((entityKey#1031 >= 3__1614174__7437210436854775807) AND (entityKey#1031 < 3__1614174__7437296776854785808))))
+- Project [cast(entityKey#1019 as string) AS entityKey#1031, cast(lsaCycleName#1020 as string) AS lsaCycleName#1032, cast(__record_timestamp__#1021L as bigint) AS __record_timestamp__#1033L, cast(__sys_nxcals_entity_id__#1022L as bigint) AS __sys_nxcals_entity_id__#1034L]
+- Relation [entityKey#1019,lsaCycleName#1020,__record_timestamp__#1021L,__sys_nxcals_entity_id__#1022L] 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-08-08 06:03:11.484048+02:00