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 (3270 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 (3196 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 (3188 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.

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 (3173 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 | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.Register now and lock in 2025 pricing—just $495!

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
• 3271 views
• 0 likes
• 2 in conversation
  • 
  •