Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

when select query fired on _employee table then it is not able to find the path of table #175

Open
Abhishek17102000 opened this issue Jun 3, 2022 · 1 comment
Open

when select query fired on _employee table then it is not able to find the path of table #175

Abhishek17102000 opened this issue Jun 3, 2022 · 1 comment

Comments

@Abhishek17102000
Copy link

Abhishek17102000 commented Jun 3, 2022 •
edited
Loading

shell.execute("""use test_db ;CREATE TABLE test_db._employee (project_id STRING) stored as avro;""")
shell.execute("""insert into test_db._employee values("1234567890)""")
shell.executeStatement("select * from _employee")

Error==>
org.apache.hadoop.mapreduce.lib.input.InvalidInputException: Input path does not exist: file:/tmp/hiverunner_tests6110231757007100370/warehouse14790178737396114350/test_db.db/_employee
@massdosage
Copy link
Collaborator

I wonder if the problem is coming from the _ in the table name. What happens if you try using employee instead?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@massdosage @Abhishek17102000