Symptom
The error message "Unsupported array expression in vector engine" is displayed while the following SQL statements are executed.
Cause Analysis
The vectorized executor of column-store tables does not support the array type. In the preceding SQL statements, a.divisionid IN (b.ln_divid, b.ln_zzgsid) is processed as an array. This error is reported because table b is a column-storage table.
Solution
Change a.divisionid IN (b.ln_divid, b.ln_zzgsid) to (a.divisionid = b.ln_divid) or (a.divisionid = b.ln_zzgsi).
Symptom 2
The message "Setup os failed" is displayed during installation.
Cause Analysis
1. The etc/fstab file is abnormal. The file contains incorrect information, leading to the failure of adding errors=panic to its mounting options by using preinstall.
2. The value of hostname in the etc/hosts file and that in g_hostname_conf in the in preinstall.ini file are different.
3. 127.0.0.1 localhost is not configured in the etc/hosts file.
4. An IP address in the etc/hosts file corresponds to multiple host names.
5. The swap information in the swapon –s command output is different from that in the /etc/fstab file. Generally, this is because swap is disabled by using swapoff but its information is not deleted from the /etc/fstab file.
Solution
1. Correct the /etc/fstab file content.
2. If the hostname of the node configured in g_hostname_conf is incorrect, modify the g_hostname_conf configuration and run the preinstall command again. If the hostname in the /etc/hosts file is incorrect, delete this item. (preinstall will automatically add the correct host name.)
3. Add 127.0.0.1 localhost to the /etc/hosts file.
4. Delete the incorrect host name.
5. Run the /etc/fstab command to delete all the configurations of swap. Run the swapoff /dev/sdX command to stop swap.
