# Pt-archiver --columns with alias

**URL:** <https://forums.percona.com/t/pt-archiver-columns-with-alias/38142>\
**Category:** Percona Toolkit\
**Created:** [May 29, 2025, 11:58am UTC](https://forums.percona.com/t/pt-archiver-columns-with-alias/38142 "2025-05-29T11:58:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![luisgasca](https://avatars.discourse-cdn.com/v4/letter/l/f07891/32.png) [@luisgasca](https://forums.percona.com/u/luisgasca)\
**Post date:** [May 29, 2025, 11:58am UTC](https://forums.percona.com/t/pt-archiver-columns-with-alias/38142/1 "2025-05-29T11:58:58Z")

</div>

I need to export a given value which is extracted with a call to a function. Like so:

`SELECT getCountry(md) as geo FROM table`

It seems that `--columns 'getCountry(md) as geo'` does not work

`DBD::mysql::st execute failed: Unknown column ''getCountry(md) as geo' in 'field list'`

Any workaround ?

Thanks,  
Luis

---

<div class="post-metadata">

**Author:** ![Vinodh\_Krishnaswamy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vinodh_krishnaswamy/32/46_2.png) [@Vinodh\_Krishnaswamy](https://forums.percona.com/u/Vinodh_Krishnaswamy)\
**Post date:** [June 26, 2025, 7:23am UTC](https://forums.percona.com/t/pt-archiver-columns-with-alias/38142/2 "2025-06-26T07:23:52Z")

</div>

Hi @luisgasca ,  
It seems you are using functions inside columns. Please let me know if otherwise. It is not supported by the utility for now. However, it is a good addition to the tool and so I have raised a JIRA for improvement [PT-2461](https://perconadev.atlassian.net/browse/PT-2461) for the same.

Regards,  
Vinodh Guruji
