Amazon Redshift ne prendra plus en charge la création de nouveaux Python à UDFs partir du patch 198. UDFs Le Python existant continuera de fonctionner jusqu'au 30 juin 2026. Pour plus d’informations, consultez le [ billet de blog ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

Les traductions sont fournies par des outils de traduction automatique. En cas de conflit entre le contenu d'une traduction et celui de la version originale en anglais, la version anglaise prévaudra.

# SYS\$1CHILD\$1QUERY\$1TEXT
<a name="SYS_CHILD_QUERY_TEXT"></a>

Renvoie le texte SQL d’une requête enfant.

## Colonnes de la table
<a name="r_SYS_CHILD_QUERYTEXT-table-rows"></a>

[\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/fr_fr/redshift/latest/dg/SYS_CHILD_QUERY_TEXT.html)

## Exemples de requêtes
<a name="r_SYS_CHILD_QUERYTEXT-sample-queries"></a>

Dans l’exemple suivant, les lignes de résultats affichent les actions d’Amazon Redshift. 

```
SELECT * from sys_child_query_text where query_id = '34487366' order by child_query_sequence asc, sequence asc;
                
user_id | query_id | child_query_sequence | sequence | text
--------|----------|----------------------|----------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
100     | 34899339 |   1                  |    0     |  /* RQEV2-aY6ZZ1ZpQK */\nwith venue as (\n    select venueid,\n            venuename,\n            venuestate\n    from venue\n), event as (\n    select eventid,\n            venueid,\n            date    
100     | 34899339 |   1                  |    1     |  id,\n            eventname\n    from event\n    where eventname like '3 Doors Down'\n), users as (\n    select userid\n    from users\n), sales as (\n    select salesid,\n            pricepaid,           
100     | 34899339 |   1                  |    2     |  \n            eventid,\n            buyerid\n    from sales\n)\nselect e.eventname,\n        v.venuename,\n        count(distinct(u.userid)) as unique_customers,\n        sum(s.pricepaid) as total_sal    
100     | 34899339 |   1                  |    3     |  es\nfrom venue as v inner join event e on v.venueid = e.venueid\ninner join sales s on e.eventid = s.eventid inner join users u on s.buyerid = u.userid\ngroup by 1,2\norder by 4 desc limit 100
```