Support Questions
Find answers, ask questions, and share your expertise

hql: SET: not found [No such file or directory]

hql: SET: not found [No such file or directory]

Explorer

Hi,

I have a hql where I have to SET properties.

SET hive.exec.dynamic.partition=true;

SET hive.exec.dynamic.partition.mode=nonstrict;

SET mapred.input.dir.recursive=true;

SET hive.mapred.supports.subdirectories=true;

SET hivevar:SCHEMA=xxx;

and when I try to execute name.hql it errors saying "SET: not found [No such file or directory]"

How to assign the properties in hql.

2 REPLIES 2

Re: hql: SET: not found [No such file or directory]

Explorer

The error was I was not executing with -f option. Thanks. It is working.

Re: hql: SET: not found [No such file or directory]

Super Collaborator
@Revathy Mourouguessane

To execute hql script you need to using -f with hive cli or beeline

#hive -f <File with hql> (or) with beeeline

#beeline -f <exec file>