ESQL does not support cross-cluster search yet; when a CCS pattern is used in a FROM command, the error message is not very clear for the end user

<img width="590" alt="Screenshot 2023-11-27 alle 15 38 02" src="https://github.com/elastic/elasticsearch/assets/459289/5af48932-4a4c-416a-a926-7bd486d282a5">

We should make it more user friendly
x-pack/plugin/esql/src/main/java/org/elasticsearch/xpack/esql/plugin/ComputeService.java
if (drivers.isEmpty()) {
                throw new IllegalStateException("no drivers created");
            }
            LOGGER.debug("using {} drivers", drivers.size());
        } catch (Exception e) {
            listener.onFailure(e);
            return;
        }
        driverRunner.executeDrivers(
            task,
            drivers,
            transportService.getThreadPool().executor(ESQL_WORKER_THREAD_POOL_NAME),
            ActionListener.releaseAfter(listener, () -> Releasables.close(drivers))
        );
    }
    private void acquireSearchContexts(
        List<ShardId> shardIds,
        Map<Index, AliasFilter> aliasFilters,
        ActionListener<List<SearchContext>> listener
    ) {
        try {
            List<IndexShard> targetShards = new ArrayList<>();
            for (ShardId shardId : shardIds) {
                var indexShard = searchService.getIndicesService().indexServiceSafe(shardId.getIndex()).getShard(shardId.id());
                targetShards.add(indexShard);
            }
            if (targetShards.isEmpty()) {
                listener.onResponse(List.of());
                return;
            }