HI My hive version is 0.14.0 installed from HDP2.2.4 On Thu, Apr 30, 2015 at 3:34 PM, Gerald-G <shadowinl...@gmail.com> wrote:
> Hi ALL: > > I have develop three UDF and compile them in one jar. Hive Explainn one > udf to antother class > > Dump INFO as Follow: Hive explain userlost-->shiftAct(), but the return > type is boolean, the right return type I want > > > 0: jdbc:hive2://10-4-32-53:10000> explain select userlost(idayacti,1) from > fat_tbaccount; > +--------------------------------------------------------------+--+ > | Explain | > +--------------------------------------------------------------+--+ > | STAGE DEPENDENCIES: | > | Stage-0 is a root stage | > | | > | STAGE PLANS: | > | Stage: Stage-0 | > | Fetch Operator | > | limit: -1 | > | Processor Tree: | > | TableScan | > | alias: fat_tbaccount | > | Select Operator | > | expressions: ShiftAct(idayacti) (type: boolean) | > | outputColumnNames: _col0 | > | ListSink | > | | > +--------------------------------------------------------------+--+ > 15 rows selected (0.657 seconds) > 0: jdbc:hive2://10-4-32-53:10000> explain select > userlost(idayacti,iworldid) from fat_tbaccount; > Error: Error while compiling statement: FAILED: SemanticException [Error > 10004]: Line 1:33 Invalid table alias or column reference 'iworldid': > (possible column names are: dtstatdate, iaccounttype, suin, igameid, > iworld, iroleid, iregtime, ilastacttime, idayacti, iweekacti, imonthacti, > igroup, ilevel, iviplevel, itimes, ionlinetime) (state=42000,code=10004) > 0: jdbc:hive2://10-4-32-53:10000> explain select userlost(idayacti,iworld) > from fat_tbaccount; > +--------------------------------------------------------------+--+ > | Explain | > +--------------------------------------------------------------+--+ > | STAGE DEPENDENCIES: | > | Stage-0 is a root stage | > | | > | STAGE PLANS: | > | Stage: Stage-0 | > | Fetch Operator | > | limit: -1 | > | Processor Tree: | > | TableScan | > | alias: fat_tbaccount | > | Select Operator | > | expressions: ShiftAct(idayacti) (type: boolean) | > | outputColumnNames: _col0 | > | ListSink | > | | > +--------------------------------------------------------------+--+ > 15 rows selected (0.192 seconds) > 0: jdbc:hive2://10-4-32-53:10000> CREATE FUNCTION shiftleft AS > 'com.shadowinlife.app.UserACT.ShiftLeft'; > No rows affected (0.064 seconds) > 0: jdbc:hive2://10-4-32-53:10000> explain select shiftleft(idayacti) from > fat_tbaccount; > > +----------------------------------------------------------------------------------------+--+ > | Explain > | > > +----------------------------------------------------------------------------------------+--+ > | STAGE DEPENDENCIES: > | > | Stage-0 is a root stage > | > | > | > | STAGE PLANS: > | > | Stage: Stage-0 > | > | Fetch Operator > | > | limit: -1 > | > | Processor Tree: > | > | TableScan > | > | alias: fat_tbaccount > | > | Select Operator > | > | expressions: ShiftLeft(idayacti) (type: > struct<header:int,tailer:bigint>) | > | outputColumnNames: _col0 > | > | ListSink > | > | > | > > +----------------------------------------------------------------------------------------+--+ > 15 rows selected (0.217 seconds) > 0: jdbc:hive2://10-4-32-53:10000> explain select shiftact(idayacti) from > fat_tbaccount; > Error: Error while compiling statement: FAILED: SemanticException [Error > 10011]: Line 1:15 Invalid function 'shiftact' (state=42000,code=10011) > 0: jdbc:hive2://10-4-32-53:10000> CREATE FUNCTION shiftact AS > 'com.shadowinlife.app.UserACT.ShiftAct'; > No rows affected (0.064 seconds) > 0: jdbc:hive2://10-4-32-53:10000> explain select shiftact(idayacti) from > fat_tbaccount; > > +---------------------------------------------------------------------------------------+--+ > | Explain > | > > +---------------------------------------------------------------------------------------+--+ > | STAGE DEPENDENCIES: > | > | Stage-0 is a root stage > | > | > | > | STAGE PLANS: > | > | Stage: Stage-0 > | > | Fetch Operator > | > | limit: -1 > | > | Processor Tree: > | > | TableScan > | > | alias: fat_tbaccount > | > | Select Operator > | > | expressions: ShiftAct(idayacti) (type: > struct<header:int,tailer:bigint>) | > | outputColumnNames: _col0 > | > | ListSink > | > | > | > > +---------------------------------------------------------------------------------------+--+ > >
