e.s = False Not Working

• Community
  • Home
  • Welcome
    • Getting Started
    • Community Memo
    • All Things Community
    • SAS Customer Recognition Awards (2024)
    • SAS Customer Recognition Awards (2023)
  • SAS Community Library
  • SAS Product Suggestions
  • Upcoming Events
  • SAS Customer Recognition Awards
  • All Recent Topics
• Learn
  • New SAS User
  • SAS Software for Learning Community
  • Ask the Expert
  • SAS Certification
  • SAS Tips from the Community
  • SAS Training
    • Programming 1 and 2
    • Advanced Programming
    • Course Case Studies and Challenges
    • Trustworthy AI
  • SAS Global Forum Proceedings 2021
  • Tech Report Archive
  • SAS Insights Archive
• Programming
  • SAS Programming
  • SAS Procedures
  • SAS Enterprise Guide
  • SAS Studio
  • Graphics Programming
  • ODS and Base Reporting
  • SAS Code Examples
  • SAS Web Report Studio
  • Developers
• Analytics
  • Statistical Procedures
  • SAS Data Science
  • Mathematical Optimization, Discrete-Event Simulation, and OR
  • SAS/IML Software and Matrix Computations
  • SAS Forecasting and Econometrics
  • Streaming Analytics
  • Research and Science from SAS
• SAS Viya
  • SAS Viya
  • SAS Viya on Microsoft Azure
  • SAS Viya Release Updates
  • Moving to SAS Viya
  • SAS Visual Analytics
  • SAS Visual Analytics Gallery
  • Your Journey to Success
  • SAS Viya Workbench
    • SAS Viya Workbench: Getting Started
    • SAS Viya Workbench Discussion
    • SAS Viya Workbench: Release Updates
• Administration
  • Administration and Deployment
  • Architecture
  • SAS Hot Fix Announcements
  • SUGA
• Solutions
  • Microsoft Integration with SAS
  • Decisioning
  • SAS Decision Builder
  • Data Management
  • SAS Data Maker
    • SAS Data Maker: Getting Started
    • SAS Data Maker Discussion
  • Customer Intelligence
    • SAS Customer Intelligence
    • SAS Customer Intelligence 360 Release Notes
    • SAS 360 Match
  • Risk and Fraud
    • SAS Risk Management
    • Fraud, AML and Security Intelligence
    • SAS Fraud and Compliance Release Updates
    • SAS Risk Release Updates
    • Risk & Finance Analytics
    • Insurance Fraud
    • MRM AI Governance Working Group
    • SAS Quant Community
  • SAS Health
    • SAS Health and Life Sciences
    • SAS Life Science Analytics Framework
• Hubs
  • Regional Hubs
    • SAS User Groups
    • SAS Community Nordic
    • AML Nordic User Group
    • SAS Japan
    • SAS Korea
    • CoDe SAS German
    • SAS Plattform Netzwerk
    • SAS Brazil Community
    • SAS Spanish Community
    • SAS Users Group in Israel
    • 欢迎来到SAS中文社区！
    • Ottawa Area SAS Users' Society
    • Toronto Area SAS Users Group
    • SAS Türkiye Community
  • Special Interest Hubs
    • SAS Hacker's Hub
    • SAS Innovate 2026
    • SAS Analytics Explorers
    • The Curiosity Cup
    • SAS Inner Circle Panel
    • SAS Hackathon Team Profiles (Past)
    • SAS Explore
    • Reporting and Optimization
    • Intern Alumni Network Community

Sign In All communityThis categoryThis boardKnowledge baseUsersProducts cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for  Search instead for  Did you mean: 

• Home
• /
• Programming
• /
• Programming
• /
• hive.resultset.use.unique.column.names = false not working

Options

• RSS Feed
• Mark Topic as New
• Mark Topic as Read
• Float this Topic for Current User
• Bookmark
• Subscribe
• Mute
• Printer Friendly Page

BookmarkSubscribeRSS Feed

• All forum topics
• Previous
• Next

angie16 Obsidian | Level 7

• Mark as New
• Bookmark
• Subscribe
• Mute
• RSS Feed
• Permalink
• Print
• Report Inappropriate Content

hive.resultset.use.unique.column.names = false not working

Posted 05-03-2022 12:58 PM (3359 views)

I have a libname with this as an option and I am still getting the table name prefixing the variable name. I am using SAS 9.4.

Here is the code. Do I have something wrong in the syntax?

libname &lib_name. ODBC dsn=HiveODBC_PROD user=&user_id. password="&hive_pwd." schema=&schema_name.DBLIBINIT='set hive.resultset.use.unique.column.names=false'connection=sharedread;

0 Likes Reply 3 REPLIES 3 ChrisNZ Tourmaline | Level 20

• Mark as New
• Bookmark
• Subscribe
• Mute
• RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Re: hive.resultset.use.unique.column.names = false not working

Posted 05-13-2022 06:13 AM (3285 views) | In reply to angie16

Long shot. Have you tried adding a semicolon?

DBLIBINIT='set hive.resultset.use.unique.column.names=false;' ?

Or change the value in file hive-site.xml ?

High-Performance SAS Coding - Third Edition 0 Likes Reply angie16 Obsidian | Level 7

• Mark as New
• Bookmark
• Subscribe
• Mute
• RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Re: hive.resultset.use.unique.column.names = false not working

Posted 05-13-2022 10:57 AM (3277 views) | In reply to ChrisNZ

Unfortunately, the ; doesn't seem to help.

Or change the value in file hive-site.xml ? could you give me a bit more info on this. I am not sure what you mean....

Attaching the proc contents so you can see all the versioning and specs.

hive_resultset_use_unique_column_names_flase.docx 0 Likes Reply ChrisNZ Tourmaline | Level 20

• Mark as New
• Bookmark
• Subscribe
• Mute
• RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Re: hive.resultset.use.unique.column.names = false not working

Posted 05-18-2022 02:30 AM (3262 views) | In reply to angie16

Run

%put %sysfunc(sysget(SAS_HADOOP_CONFIG_PATH));

to see the location of the xml files that define your configuration.

High-Performance SAS Coding - Third Edition 0 Likes Reply

April 27 - 30 | GAYLORD TEXAN

SAS Innovate 2026 Registration is Open

Register now to lock in early bird pricing through February 25!

Register Now → How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats

• 3 replies
• ‎05-03-2022 12:58 PM
• 3360 views
• 0 likes
• 2 in conversation
  • 
  •