Closed dmgaldi closed 7 months ago
The above can be disregarded. The select still fails in the latter example with column names provided.
However, it seems that quoting the field name works.
This works:
select STABLE_ID Avenir_1_cluster_subsetteddata_stable_id,
"TEMP_Cluster_ID", stable_id
from apidbuserdatasets.attributes_auto_20230606183330_fbXU_1_Avenir_1_cluster_subsetteddata
This doesn't:
select STABLE_ID Avenir_1_cluster_subsetteddata_stable_id,
TEMP_Cluster_ID, stable_id
from apidbuserdatasets.attributes_auto_20230606183330_fbXU_1_Avenir_1_cluster_subsetteddata
Note the quotes around TEMP_Cluster_ID
I'm not familiar with the comma syntax in a FROM clause of PLSQL, but it might be the source of the issue here?
I'm seeing:
SELECT * FROM apidbuserdatasets.attributes_auto_20230606183330_fbXU_1_Avenir_1_cluster_subsetteddata,apidbuserdatasets.ancestors_auto_20230606183330_fbXU_1_Avenir_1_cluster_subsetteddata;
returns 1 column, excludes two selected columns
SELECT * FROM apidbuserdatasets.ancestors_auto_20230606183330_fbXU_1_Avenir_1_cluster_subsetteddata;
returns 3 column, includes all selected columns