如何选择列并在Hive中执行TRANSFORM？ [英] How can select a column and do a TRANSFORM in Hive?

问题描述

我用变换USING 与蜂房0.8.1，并且注意到，这是无效的语法：

<$ P （b，c）使用'fake.py'AS d，
FROM test_table;
，
使用'fake.py'

删除a会使此声明有效。什么是使用这个的正确方法？

解决方案

显然这是不可能的。 fake.py 也必须处理这个问题，也就是说必须这样做

  SELECT 
 TRANSFORM（a，b，c）使用'fake.py'AS a，d 
 FROM test_table; 
  

并使其成为fake.py输出'a'。

I was using TRANSFORM USING with Hive 0.8.1, and noticed that this is invalid syntax:

SELECT
    a,
    TRANSFORM(b, c) USING 'fake.py' AS d,
FROM test_table;

Removing "a," makes this statement work. What is the correct way of using this?

解决方案

Apparently this is not possible. The fake.py has to handle that as well, i.e. one must do

SELECT
    TRANSFORM(a, b, c) USING 'fake.py' AS a, d
FROM test_table;

and make it so that fake.py does output 'a' as well.

这篇关于如何选择列并在Hive中执行TRANSFORM？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！